I have three footers in my report:
    COM_VAD
    PROCESS
    LABEL_TYPE

I have a report with a sub report on it, when I run the report in the .ADP
application the report works fine,  when I create an .ADE and run the same
report it does not run, I get the following error: "The OpenReport action
was canceled"  After further research I found out that ...

I need to create a report that basically shows employees who have completed
something similar to a hiring process.
The criteria to indicate that the process has been completed is:
1.  The presence of 4 dates in a table.  The presence of each date

I have a report with 8 columns across.  We enter information into the fields
in columns 1 through 6.  
Total of column 1 through 6 is automatically calculated into column 7
Total of column 2 through 6 is automatically calculated into column 8

I have a report that I need to print every Friday, but the report is for the
following week.  So, I want it to say "For the week of:  Monday, November 5,
2007."  How do I calculate the date to be next Monday?

I've created a multi-column report that prints labels in the first
column of each page. Everything looks fine on the screen when I print
preview. However when I print out the report, the labels do not print
out on the first page but the rest of the pages are fine. Can anyone

Basic question (I hope).  I have a report that groups meetings by week -
currently the group header uses this:
=Format$([MeetingDate],"ww",0,0)
Naturally what you see on the report is the week number (like 44, 45, etc..).

I generate a report that shows all my shipping info for a certain month or
week.  I am using a parameter query that requires the user to input the
beginning date and the ending date.  I'd like to see that inputed info on my
header, i.e. "Shipping info for the week of: (this is ...

I have a report that uses a cross-tab query.  I had to set the column
headings in order to get the query to display in the report.  
This is a report that is put out monthly and will only have details for 6
months worth of information at most.  Once created, this report will get

I have a from that you can select a field to filter a report by.  These
fields are comboxes.  Can I have one report to filter this by?  What do I put
into the report under filters to filter it by?  Do I put the combox name or
what it is filter by?  I have one report that can be ...

Budget is our income and sometimes this is positive.  I need to make this
column in a query all negitive values.
I am using the IIf function but it is not working.
Budget: [budget_amount] IIf ([budget_amount] >=0, [budget_amount]*-1,

How do I call up a specific report based on 2 or 3 fields in a query or table?
I have 4 reports, each design somewhat similar, but a paragraph different.  
I would like the form fields (CustomerID and ContractID) determine which
report opens to print or preview.

I have a main report that has three different subreports on it, all three
subreports come up fine and have multiple entries in them. But one of the
reports is causing my main report to print a page per entry (eq. if the
subreport has three entries in it then i get three pages of ...

I have a report called Associated Fund Interest.  It has a grand total in the
report footer.  I also have a report called Monthly Investment by Fund Less
Associated.  This report has four fields:  Fund Name, Fund Number, Face
Amount and YTD Interest.  The face amount and YTD ...

I'm using Access to build a database at work.  I am entering data on a daily
basis from invoices that I wish to sumarize by various periods of time
(daily, weekly, monthly, etc....) so have built From and To parameters into
my query.  When running reports, I get #Error for the ...