I create an form in Access which requires an employee ID # to open the Form and enter data on the employee, the data then appears on a 5 page report. Problem...

I have created a report that I need to put the grand total at the bottom of for two of the columns. What I have done is put two unbound text boxes in the...

Hi, all: I usually put a line at report footer to indicate the end of the report. In multiple column report, if the report ends at the first column, the line...

I need to calculated a percentage for specific criteria on a report. My table has various indicators Apples/Oranges/Grapes. Reviews are being done on the...

Using Access 2003 I am trying to modify a database that I did not create. On one of the reports there is a combo box (I'm not sure why a combo box was used...

I am putting a formula into the deptnum Footer - it is grouped by deptnum. so the if then I am using is just Looking at the dept num within that group so the...

I have a report that gives me a percent in one column. I want that column to round up if the percent is less than 1. Right now it's just showing as 0, but...

Hi there, In a detail section, is there a way to get the previous field value in the previous record? I'm asking this because each current is calculated with...

I'm getting a runtime error 13 -- type mismatch and not sure why i'm getting the error. The error is pointing to this line below. The report worked great,...

Hi, I was wondering if anyone has an idea on how I can create a percentage automatically. I have a field with the following as a control scource: =(/) wnen I...

Ok I have included the code that I'm using below. It does work with only one problem, it will not line up correctly. Now I'm figureing is possebly the fonts...

I have a table that contains the following fields: Date, BatchID, Charge, Description, Amount I want to create a comparative report show the sum of all...

I have been able to place a sum in the page footer following Article ID : 296249. However, when I try to sum multiple columns of values, the sums...

ACCESS 2002 I have a query with the main fields being Region, System1, System1Comments, System2, System2Comments, System3, System3Comments, ....System6,...

Using Microsoft Access 2003. I'm attempting to write a custom function to strip out some characters from a field, then total the leftover numbers. The data in...

Hello, I want to make a report that summarizes how many hotel rooms are reserved per night. I need to modify the following code: Date = CheckInDate Do Until...

I have a report sorted by week ending date. It looks something like this. 1/02/2005 1 5 10 74 1/09/2005 2 6 12 ...

I have a table where each family member is in a separate record (imported from another program that has it that way). There is a fldFamilyIDNumber field. Each...

I am trying to figure out the proper way to display data that meets a criterion in a different color than the rest of it. For example, I want to display all...

Hi again, In order to solve the problem I mentioned in my last question, I tried to create a function that should return the string with the criteria of the...