I would like to create a command button that will print multiple reports just
by clicking it once.
I have several different reports displaying information related to a
specific record in a variety of ways, with only a unique ID# being the same

I have one table that contains the purchases for the year. Fields
are:item_nbr, Qty and period. I have another table that contains the sales
for the year. Fields are: item_nbr, Qty and Period.
Is there a way to make a report that shows qty purchased less qty sold for

i want to add a if function to a report. However Im not sure how to do
it.
If the date of a course is greater than a month then i want it to
display the message:

I can not get conditional formatting to work..
Have 3 TEXT FIELDS that are currently bordered... I want the border cleared
if one of the fields meets a certain text requirement... Or I want all
"cells" shaded if that requirement is met... I would prefer to have the

I have a report that tries to read from a temp table that I create right
before I call the open report command.  Problem is - the report generates a
2580 'record source not available' error because I believe that report is
trying to open too fast.  The table probably is not built ...

Access03/WinXp
I have a badges report for a convention database that displays a convention
logo based on a field in the table containing the path and filename (set in
the report OnOpen property).  This works without issue.  The basic image

I dragged a Report to another Report..to display as a SubReport...
It doesn't display.
Ideas?
TIA - Bob

I'm trying to display the sum of data in a report footer, but can't quite get
the expression to work.
In one of the grouping levels, BidNumber, the header contains a control named
BidType, and another calculated control that sums records in the detail

Is there a way to tell an invoice to print so many lines then break? I could
put a page break in but we have text that prints after the lines of the
invoice print and I don't want them to be broken by putting a few lines on
the 1st page of the invoice and the rest on the second page ...

I have created a report that generates based on a persistent query.
What we would like to do is be able to add or remove certain fields
from the report as required by a form.
We would like to use a check box for each field.

I am still stuck with this so, I will explain it in more detail:
I have 4 tables. 2 are for expenses 2 are for income:
Tables:
1) Invoices

I've created a report with a subform. The subform is displayed in datasheet
view and one of the fields is a date. I take the maximum date and print it
elsewhere on the report body. This works fine. The issue I'm having a problem
with is that I also need that date to appear in the ...

I have a report which displays Expense information totaled by month for each
employee. The report is grouped by employee.
I would like to display budget information which is calculated in a separate
query for each employee.

There is a report in MDE file. If the user preview the report and change the
paper size from A4 to Legal, I want if he preview the same report in the
next time, the report will be displayed in Legal size. Is it possible to do
like that for MDE file ?

I have a DVD database with close to 1,000 titles.  I am trying to create a
report  where the DVD's are sorted by Movie Type, then alphabetically, then
numbered.  So when I'm looking for a specific title, all I have to do is look
at the alphabetic list and easily find the title by ...