I have created a chart in a report based on a query.  The
query is a simple Count and Group By query with two
columns (Count Of and Objects) and about 7 or 8 records.  
The chart works just fine with the query.

Here is another problem for you. My report's page settings do not
retain the settings I want.  For example I want my  reports to have:
Margins with Top: .25; Bottom: .25; Left: .25; Right: .25, with
Paper size: Legal

I use Running Sum (Field Subtotal) in a report.
This is what report looks like:
Subtotal    Running Sum
========    ===========

I have a dropdown list based on a query.  The list shows
only names, but the query includes a field which
determines which report to open.  What is the most
straightforward method to have the field make that happen?

I developed a program in office 2K. When I convert it to 97 The line
           DoCmd.SendObject acSendReport, "RptTaxReciepts", acFormatSNP, _
says variable not defined It points to acFormatSNP
What do I use in access 97 to mail a report in snapshot format?

I have created an MS Access report and have overlayed a
transparent .gif image on top of another image. The image
seems to lose it's transparency in the report. I have
confirmed that the "Back Style" property of the image is

Does anyone know how I can save Access reports as PDF documents? I know I
can do this using an add-in that comes as part of Crustal Reports but I was
hoping for a cheaper solution if possible.
Any suggestions appreciated.

I have a tool calibration database and want to create an
over due tools report. Each tool has a ID number assigned
(Key value), as the tools came back from calibration, I
enter in the database the calibration info which include

I have created a  report that shows, the employee in each department.
Now, I have to add two fields, the serial number and total number of
employee in each department.
How can I do that..? Please help.

I have a report with a multi-column subreport.  It works great, however, it
is creating an extra page at the end of every overall report.
Here is some setting I have:
The report has two grouping

I have a database that prints labels for our products.  A problem occurs if
the product name is long and extends over two lines of text.  This knocks
the label sizing out and we end up with the next row of labels being blank.
I have tried setting the text box properties to Can Grow ...

I have an option button group for PmtType on a form.  How
can I convert the numeric value of the selection to text
for a group header in a report?  For instance:
1 = Cash

I have a report which must print out on a paper form.  
However, occasionally the forms are cut just a bit
differently, causing me to need to 'nudge' the text a
hair to the right, left, up, or down.  I would like to be

-- I am building a training database.
There are systems within database.
Thers are at list 5 sop,s that a person must train on to be qualified to
operate system.

In my report code I have a format event for the toptext on page section.  I
need to go trough every label in the section and do a couple of things like
setting the caption and the borderstyle. I belive it's a good idea to use
the for each statement, but I can't figur out what to use ...