As with my post just a while ago, i have a second question relating to this - I have records Pests such that if a Pest is found in a location - "1" is given,...

I have a form where the sum of a particular datasheet view field must be shown. Essentially it is a time tracking form where each step is recorded in the...

Hi guys I have been pulling my hair out with this issue!!! I have a form with a number of bound and unbound fields on it. I use the SUM function via the...

I'm constructing a system for selling materials and services. One record in the database represents one sale. I'd like to do the...

I have 50+ years of salmon counts at dams in the Pacific Northwest and the data is organized in a table with the following column headings: YEAR MONTH# ...

I have a multi page report which includes a field to calculate the *. I would like to have a sum shown at the bottom of each page and a grand total at the...

I have a table with the following fields: ITEM TOTAL REF The data is imported from Excel & the value in the ITEM field may be repeated for an instance in...

Hello, I would like to obtain a sum total on reports for billing codes that identify patient charges.I have various codes so i want to specify them by their...

Hi, I’m using Access via XP Access Pro running in XP Pro with SP3. Please note that this question was posted in both the Database design and Form coding...

Hello everyone, I am new to this forum but have been using Access for sometime now. I am no expert by any stretch of the imagination. My question is - i have...

I am trying to find the best way to make a report of summery of the information collected in my database. I need the total number of calls, percentage of...

I have created a report that uses the counting procedure, now I need to total that procedure. I also need to know how to save the program to a CD so that it...

Work with IT for many years, and have lately begun looking into DB and MS Access. So Im quite a rookie in this area. :) Ok, Got a superclass named table1....

Hi, I'm in the process of designing a database for certain geographical areas. This is will be one of the first databases I create. I've identified some...

Hi, I have a table called Tbl_Person where I have (PK) Person_ID and a field Supervisor_ID. I am able to establish a supervisor from a combo box on a form...

I am coming up at a loss on how to design this particular database. I exported from Solomon my inventory list of supplies for my branches as a csv. I...

I am doing a supporters club booking system for Leeds United, (for school A2) I have a field with every match, then on the left, the members are listed,...

I have a db that resides on a server and is shared from a number of different locations. I have designed an updateable form based on a query that is not...

I have a form from which I open all the reports of my datebase, but on my reports, I have activated the On No Data event. This event works well whenever I...

How can I remove or gray out certain areas of default menus in my MDE? For example, in the "Tools" menu, I don't only users to have the options of Spelling,...