On a report that prints labels, I want to be able to
toggle an image off and on based on whether their order
is paid.
The query behind the report calculates 'balance due' and

I currently have a report that runs an invoice for all clients and
prints to Acrobat Adobe and creates a .pdf file named as the Report
name (PhysicalAuditInvoice).  This report then contains every invoice.
To create individual .pdf files for each client, I have to run the

Good evening,
I'm a novice Access user.  Here is what I'm trying to do.  I'd really
appreciate some input or suggestions for getting this to work.

My report has a field that prints the field only if the
number is positive.  I have a negative number and it does
not show...however, it is included in the sum function.
The number exists in the query of this report.

I am having issues with my date range in a report. I read
through Jeff Conrad's instructions from yesterday and
they worked great ("How do I add a date range" e-mail).
However, the particular report that I have created pulls

I have a button on a form that opens a report with
the "OpenReport" macro function. If I open the report,
close it, change a value on the form, save the record,
and then open the report again, it is not updated. In

Hi group,
   I have a report with the following SQL, that list all sold products and
their quantities.
   I wanna count them all, sold products, at the final of the page.

I HAVE AN APPLICATION RUNNING FROM WHICH I NEED TO PRINT
ENVELOPES.  THE APPLICATION IS AN ACCESS 2000 APPLICATION
RUNNING UNDER AN XP OPERATING SYSTEM AND TIED TO DATA ON A
NETWORK SERVER, WINDOWS 2000 SBS.  ONCE I CANCEL AN

I have a report where some fields have "can expand" set to
true. Not all the fields have a need to expand. The result
is a report that looks "bumpy".  On a row where the field
is expanded the bottom border for that field expands and

is there a way to control my report printing?
i will be printing a report (full duplexed)
page 1 & 2 will be on heavier stock (i.e. tray 1)
and the rest of the pages, on ordinary bond...(tray 2)

Hi!  I am trying to create a form that will create new
reports on an ad hoc basis.  Basically, I have one large
Query that contains Volume figures for a number of my
products.  What I would like to do is create a chart from

I NEED TO CREATE REPORT THAT HAS TWO SUBCOUNTS.  FIRST BY
DIVISION WHICH I AM CREATING BY GROUPING AND THEN PLACING
THE DIVISION IN THE GROUP FOOTER.  SECOND WITHIN EACH
DIVISION, BY CODE.  SO IF THE DIVISION WERE CONTRACT, I

I have created a report, which is to genearted supervisor listing. List all
the emp under each supervisor.  now, I got new requriement that whenever the
supervior changes put it on the new page...
How can I do that..? please help..

How would I go about calculating dates between two dates
if 1 day = 8 hours? Here's my senario.
I have been using this formula to calculate days between
two dates (timestamped):

Hi - I am trying to combine several reports into one
report. I created one report and dragged and dropped the
reports into this one's detail section. When I preview
the first report is coming out on 25 pages.