I have a report that prints by clicking on an print command button.  
Sometime this report will be one page and sometime two pages.  If the report
is two pages I would like to print front to back on one sheet of paper.  Is
there a way to pause between the pages with a messge to ...

Can someone please help me get the " and ' right for this?  (PARTNUMBER is a
text field).  I just can't get it...argh!
DoCmd.OpenReport stDocName, acPreview, , "[PARTNUMBER] =" ' "&
Me.PARTNUMBER" ' "

In my access database, I created a check request report which recognizes a
query.  How do I get the report to go to the next record within a persons
record if there are more than one expenses.  It wants to print up a separate
report for each expense which gives the report total ...

I have come across the following KB from Microsoft that has helped me to
print a fixed number of copies of the labels that I wish to print.  This
works pretty well.
http://support.microsoft.com/kb/299024

I have a report that is based on a cross tab query.  the column headings in
the query are dates.  I have grouped the report by States and region.  I
would like to do a subtoal by state and region and also a report total.
How can I set the text box in the group footer to sum each ...

in my report i have Qty, UP2, and NetAmount. NetAmount =[Qty]*[UP2]
my [Qty] is = 5
my [UP2] is = 170.86
now when my NetAmount comes up is says 854.32, when it should be 854.30.......

I have just done a clean reinstall of Windows XP Pro and Office 2003 along
with the other applications which had been previously installed. The computer
is on a simple workstation  network with another computer running Vista X64
and the printer is connected to the Vista computer. ...

My report shows monthly meeting information [date, event, location, time,
etc] grouped/sorted by date, then time.  How can I get the report to start a
new page for each week, beginning on Mondays?  I just have the table of
information and the report, no query.

I'm working on an audit report and I need to do one of two things:
1) switch the horizontal and vertical axes so that what would normally list
the funds in the detail section will now list the funds across the top
OR

I have created a field in a report that is calculated. I want to sort the
calculated numbers in that field from high to low. Is that possible?
Exp.
=Sum([Boat Price])

I have tables set up, linked properly, forms, etc. Since I did forms and
subforms, I had to create separate tables and link them, so I used a primary
key ID in the tables. So far my database shows it is working - when
information is entered into the form, it shows up in the ...

I have a unbound report which contains 4 sub reports which are bound to 4
crosstab queries and these are based on 4 queries. The question is can I have
a combo box on the unbound report to filter the sub reports. If so. How?
TIA

I am reporting on orders analysed by advertising source.
I have built my first crosstab query that works fine, and then a report
based on that which also works OK.
However, we need to select the date range (order date) for which it is

I have a table which lists all possible items for a vendor. I want to create
a form that shows all of the items. I want the user to be able to place check
marks next to the items they want. I then want to run a report which shows
all of the information about the items, but only ...

I'm currently developing an MS Access Data Project (.adp) in MS
Access
2002.
One of the reports within the DB uses data that is Dynamic and cannot