I'm not sure why this is not working.  It is returning all records instead
of just the desired criteria:
Report Source is:
 SELECT InvoiceHeader.*, InvoiceDetail.*, Trim(InvoiceHeader!fname) & " " &

I have designed a report based on a query ... >=[Enter Date].  This is to
select only records for the report beginning with a certain date.
When I run the report, I do get the popup to enter the beginning date.
However after entering that, I am being asked to enter criteria for ...

Posted a previous message about setting a sub-reports record source
property using VBA, but I think I'll be a little clearer as there may
be a better solution I am just not aware of.
Here my situation. I have 2 reports. Lets call them Parent and

is it possible to change the text shown in a textbox of inside a report via
vba. i.e. i desire to program that if the current value of a field is NA,
then on my report i want to display "-". if so how can i do this. thks ken

Can someone tell me how I would create a rolling total in a report. Rolling
Total mean whenver one month ends the oldest month drops off of the report.
Please any help or direction would be greatly appreciated.

Relative newcomer looking for some help.  I have created a contacts database
and would like to print the data in a booklet form.  The pages will be
landscape with the data for the first page of my booklet on the left half of
the landscape paper and the data for the last page of ...

Is there a simple solution to the following:
We run year-to-date reports monthly from which we would like to create
monthly reports by comparing last months year-to-date report to this months's
year-to-date report.  Is there a simple way to save a report and then create

I am sending a query out to a spreadsheet format:
DoCmd.TransferSpreadsheet yadda, yadda, yadda, conPath & "yadda yadda" & " -
Saved_" & Format(Date, "mm-dd-yyyy") & ".xls", True
I would like this portion to show the date AND time:

I am using Access 2000 and am having trouble generating a report. I created
an unbound form that prompts for criteria for the query associated with this
report. I set up all of the macros that I needed to open, close, cancel the
query. I tied the macros to my report on the report ...

My report contains about 6 sub reports.  However when I preview the report it
shows the 2 pages correctly but then repeats these pages over so that I end
up with an 8 page report - the first 2 pages repeating over and over.  I have
checked all sub reports to make sure there are ...

I have a macro that opens a form & gets a combination of user input along
with data from a query that the form is based on.  I would like one of two
reports to print depending on the value of one data field which can only be Y
or N.  How do I get this to happen.  I was trying to ...

Is there anyway possible to set the record source property of a
sub-report programatically for each record of the parent report?
Due to what seems to be a bug in Access, a Left Join query I have is
not working properly and the only way I can seem to get around this

I need some ideas on how to solve a problem. Excuse me for the length of the
post; I’ll be as concise as opssible. I need to create a report in which
weekly school attendance and class data appears in the following cross-tab
format:

I have an expression to sum three values from a linked (to Excel) table. The
expression was built with expression builder but the reports prompts for
"enter parameter value" with a reference to the table name "CO 2005-11-30".
Why?

I created a report based on a table of property listings. Under one
location(say #15), there can be many buildings(A, B, C, etc). I needed an
overall sum of location #15 so I created a report and subtotaled each
location #. I need the report to only print for locations valuing ...