have a table that has cleartext assigned to each code such as 4, 41, 411,
4112,etc
Each representing a level deeper into an organization chart.  I've been able
to get a n excel report that will give me all of the codes in cleartext, but

I have a report that prints on a HCFA 1500 claim form.  I have spent a
significant amount of time formatting it so everything prints perfectly on
the paper form.  All text is Courier New, 12pt, and all lines across the form
are parallel.  I now need to print some of these forms ...

I have a database logging the number and type of telephone calls coming into
our office. There are a number of different reports providing various
statistics which the operators can run individually, each report requiring
only the start and end date for the reporting period. This ...

Until today I was using MS Access 2000 for database managment.  I switched
to Access 2003.  Using some code I found in the knowledge base I used a
function for calculating a total of the detail section for each page.  It is
as follows:

I have a report called "Statement", it is a billing statement
The expression below works to calculate payments that have been made to a
particular orderID.  However I need it to insert $0.00 if there has been no
payments made for the order.  I have tried using nz to no avail.  How ...

I have set up a report that shows delinquent payments.  
In the report I have information grouped under client
name, then all items purhcased to which they are
delinquent on payment...

I have 2 fields, RECORDS which is numeric, and BINARY which is text.  For the
report, I need to set the Records column to display the number from the
RECORDS field most of the time, except in cases when the BINARY field is
"Yes", then the RECORDS column in the report should read ...

Due to Rick I found out how to print a list of many stores from the same
report into a separate pages; now, how I can export/ or e-mail every
page/store separately/ or to a separate fiel?
Thanks a lot,

I have a subreport within a report.  The main report shows monthly data and
the subreport shows YTD data.  Both reports are grouped.  The subreport is
duplicating data, the main report is not.  If I go into the report that makes
the subreport, it does not duplicate, only when ...

I have 4 reports that I cannot see in the reports window of my Access XP
database.  They are only visible in the VB Editor.  I assume they are the
result of some sort of error as they are copies of legitimate reports but
their names are something like ~TMPCLP335501.  The problem ...

I have a report called Statement, I am using this expression to calculate and
display all payments made to each order:
=IIf(IsNull([OrderID]),0,DSum("[PaymentAmount]","[Payments]","[OrderID]=" &
[Reports]![Statement]![OrderID]))

I have a report with a number of values sources 1, sources 2 etc upto 20.
Each is a text box so on the report I put
="(" & "" & [Source 1] & "  " & [Source 2 & " etc...
However if one of the fields in empty I don't want a space between the values

I'm building a report to generate invoices. There are several different
items (with different fields and layout) that could be on an invoice but they
may not be on every invoice.
Of course I want to have the report only display items that are being billed

Access 2002 doesn't print check box though shows in preview?

   I am doing a database for work, and I am trying to print a report that
is a truck log.  I have everything working on the daily truck log except one
things.  What I can't get it to do is display the dropped message when a
trailer if dropped.  With in the database, I have a ...