I have a main report, ITEMS, and a sub report, SOP Items. When I run
the main report, the records from the subreport show under each record
of the main report:
main item #1

Hi all and thanks for reading,
I'm working on a school's reports database. The final report contains a
subreport, called FinalReportSub (which also contains various other
subreports and extensive use of VBA). The FinalReportSub report generates

I have built a invoicing system and am tring to build a report that
will print a field in the page header depending of if a condition is
satisfied in th detail section.
We sell products that are in 6 different warehouses, Whs1 - Whse6.  So

I would like for a field to round up a calculation and
then sum off of the rounded up number.  
Is there a way to do that?
Thanks.  

I have a report with a sub-report on it.  The main report is always a single
page.  I am printing it with a Docmd using a wherecondition.  The sub-report
however contains dated entries.  I sequence the sub-report descending and
only need the number of dated items that will fit on ...

In my report, Detail.format event, I write code to display
a field based on the value of another field.  But if the
query the report based on returns no data, it gave me
error when I open the report. How do I check if the report

I have created a report that serves as an update as it
lists only records that have been changed and/or added
since the previous report.
The table contains a check box field to indicate whether

I need to get the date and have it on a report for the
date that the Invoice(report) is first printed.  If the
invoice is pulled back up on a future date I need that
same date to be on the invoice.

I have a report with several categories.  I wish to total
the number of a specific category that does not apply to
each record.  When I use =Count([Item]), the report
totals all records, not those rows with information in

I am not sure how to ask this with describing exactly
what I am doing, so bear with me.  ON a report, I have a
total of each differnt race....however, there is an other
catagory so they can list the country of origin.  For the

I have a report where I've got a text box that could be
one of two values that it pulls from a query.  I'd like to
make another box that changes based on what appears in the
text box.

I have a legal landscape report created in Access 2002 (saved as 2000) that
another user is running in Access 2003. Sometimes their report previews in
letter landscape. I am aware of a settings problem with Access 2000, but not
with other releases. Any ideas on how to solve the ...

How can I create one report that is suitable for many queries? Is this
possible? How is this done?
I really don't want to make a report and save it to 20 different names, then
allocate a query to each. Especially if I have a small change I want to

Reports from an Access database we have created contain a
grey background colour which I am unable to change or
override to white or any other colour.   I have tried
changing the report properties of various sections without

Is there a way to have the print dialog box default to
selected records instead of "all records".  I have a form
that users will select the record using find, enter some
data, then print.  Afraid that they will mistakenly print