how do I get the average function to ignore columns that have 0.00 as the
amount.  Or is there a way to hide the zeroes like you do in excel.

I have a report that list various files that are being worked.
Example:
FileName     ProjectNumber
abc              1

is there a way (well, i know there's a way) to input the number of copies to
be printed for a report w/out going into print properties at print time?
thank you,
//frank

I don't know if this is possible, but I will ask anyway:
I want to write a report that will be based on a query.  The maximum number
of records that can be returned from the query is 90.  However, instead of
printing each record one line after another, I would like to print three

I have a report that I want to pass the results of a function to.  The
function (which captures the user's NT Logon ID, is written by Dev Ashish and
works Great!) is in a module and runs on an On Open event.   The name of the
unbound control is passNTUser and has a value before ...

I have converted a .mdb app to use linked tables to SQL Server. When running
one of the reports (only one of them) I get the message "An error occurred
when the command was run". Is there a way of debugging and/or getting more
info about the error?

Is there a way to add more than 6 fields in a chart for a report?
Thanks,
Ray

MS Access 2K, Windows XP
----------------------------
Hi,
In the Access application I've created, the following boxes are NOT checked

An Access 2003 report consists of several subreports.  Each subreport has its
own totals.  The bottom of the master report summarizes the data by adding
and subtracting totals from each subreport.
When each subreport contains data, everything works great.  However, when

i've created several reports. Can anyone please advice how make the reports
read only. Similar to Excel read only format.

In my report I need to concatenate values of the same field but different
records (the output being something like "This month we've got orders from A,
B, C, D, F, Y, MM", A, B, C etc. being the values of the different records of
the same field). As I understand, "&" operator ...

All,
I have the following piece of code in the Detail_Print section of a report.
       Line Step(Me.Text126.Left, Me.Text126.Top)-Step(Me.Text126.Width,
lngRetT), vbRed, B

I need user to type date range for report.
I have a query qryMainGoals.
I have a form frmInputDates.
I have a report rptMainGoals.

We have been using an Access 2000 database application for several years.
Recently after we generate a report in Access we try to email it or print it
in Word, This results in an output with missing data vs the Acess report.
What could vbe causing this?

I am getting truncated reports when using the "Publish It with Microsoft
Word" tool while viewing a formatted report.  The truncation doesn't occur on
every database record reported, but consistently occurs on specific records.  
Size of the record text field doesn't appear to ...