I'm using Access 2000 to print shipping labels.  I have designed a
user-friendly form to choose which records need labels.  Is there a way to
specify the number of labels to print for items with a quantity greater than
1?

In a multi column report, how can I have column labels appear over EACH
repeating column.  I can put them on the left-most column only.  Is this
possible??
Thanx -- David

I am REAL happy with my "Company Partners" report. I know that I can copy and
paste this report. How do I change the tables it is accessing to report on
"Company Clients" as opposed to "Company Partners"???
Thanks for your help!

I have created a report and the groupings I wish are by Company and then
Partner Companies within Company. When I go to print, I get my Company
Header, then on the NEXT PAGE, the Partner Company Info, and then on the NEXT
PAGE the Partner Company Details. I would like all this to ...

Please tell me how to delete blank pages in my report.  I have several and
don't know how they got there.

I am using Access 2000 and have reports which possibly have no results to the
respective query. The report will display #error because the result set is
empty. I would instead like to display an information box stating that "There
are no outstanding stars to be distributed".

Is there a way to hide specific rows that contain blank or zero values based
off of several fields in a specific record.
There are about six different textboxes associated with specific fields that
sometimes may be blank or contain zero values. I am wanting not to show a

When I upgraded from Access 2000 to 2003 the font size of a report is no
longer compressed.  Where do I change the size?

i want my report to look like the following,
Between [StartDate] and [EndDate]
=PartNumber Header===============================
Part Number       [PartNum]    

I am looking for a procedure or process or script that would allow end users
on the web to click a button and retrieve an existing Access report and
create a PDF on the fly from that report to be able to download.  
Any suggestions ?

I have a report where the source is a query containing a union.  The data
field values print but show no formatting.  I have set the format in the
report fields to their proper type (currency, percentage, etc.) but they seem
to be ignored.

I have a dataset that contains verbal orders.  It is required that verbal
orders are reviewed.  The dataset have the order date/time and the review
date/time.
I need to create a report via a query that counts the number of orders that

I want to get a sum of a column, but if there is no data
in the column i would like to print out a zero.  Now, i
understand that there is a built in function Nz in
Access, but could i use it in my report?

I have a report to do that has multiple lines of detail for each of several
sub-headings. The report is laid out as follows:
    Admissions
    Name    Date

I'm having trouble with getting my text to display in title case on my
reports.  I don't care how the operator inputs the information, but I do care
how it looks in the reports. I'd like the names to display with the first
letter capped and the subsequent letters displayed lower ...