My report calculates upon the total of the subreport, but some records on the
main report have no corresponding records on the subreport, so in the
calculated field on the main report, I get "#Error".
Main Report: Item Invoice

I am currently trying to calculate the sum of all the purchases done by a
particular customer. I have no problem coming up with the sum. However, I am
not able to display the report with both details of a particular person, the
product purchased and the total sum.

I have a report which has 2 subreports in it. (i.e main report calls
subreport1 which calls subreport2). Now when  I run the main report
there are blank spaces between each group ( the report sorts by  2
columns) therefore for each change in a group there appears a blank

i do have the same idea of creating a report. i've tried your way.. and this
error message came up
Run-time error '3075'
Invalid use of vertical bars in query expression ......

I keep all of my Sales Info in A seperate Database called History.mdb  I
want to run a report from my main Database called Current.mdb.  I'll be
using some tables from both.  First is this possible?  Or do I have to
import just what I need back into the Current.mdb.  If so how ...

I have a table in which several fields allow for the selection of multiple
values.  In my report which lists the table records, it lists a duplicate
record.
Ex. The table has the following fields:

I have some reports that do not open correctly with certain HP LaserJet PCL6
drivers (4060 and 2200 at least). They open apparentlly zoomed but actually
print across 10 pages instead of 1.
Per Microsoft, this is due to some problems with those particular drivers;

I have been successful many times formating a number in access by using the
properties button in design report. I have a calculated (division) number
field that will not format to zero ddecimals. I want to format it in the
report not the query.

I need to print 3 receipts per page. The 3 will be separated and stuffed into
window envelopes. I can't get the spacing correct for the top/bottom margins
and spacing between the receipts so the 3 are identical size and design. Is
there a template out there somewhere?

How do I do this? I have used DoCmd.OutputTo, acOutputReport but I do not
seem able to specify a format that will open the report in pdf.
Thanks!

i got a report in excel that can be made to shrink to fit on 1 page. i've
created the same report in access now thanks to douglas. is there a way to
shrink it to fit on a single page?

I have a month of data laid out by days.  i want to highlight the weekends so
i placed a box behind the fileds which can then be made .visible true/false.
in vb i would use something like... if weekday([Mydate])=1 then
me.box49.visible true else me.box49.visible false. not too ...

Poop is waste of the body.
Can anyone tell me more?

What's the best way to create a report (tabular) that has variable number of
fields (columns) which is based on the output of a query?
Most often I do not know how many fields will be displayed on the report, so
what I do is create as many textfields as possible and set their ...

how to open report and print out page 2 to page3
"docmd.openreport " can open report and print out all pages ,how can I only
print out page 2 to page 4?