I have a master report that contains invoice header information and a
subreport that contains invoice details.  The subreport works fine when run
by itself but when inserted in the master (invoice header), it displays two
instances of the subreport. This is being inserted in the ...

I have a label that print the following:
=IIf(IsNull([SerialNumber]),[NewCode],[NewCode] & Chr(13) & "S/N: " &
[SerialNumber])
If the Serail Number is not null, I want the serail number display below the

I have reports created where the filter is created based on criteria chosen
from the calling report.  Additionally, before the report opens, the user
enters a beginning and ending date via an input box, and those dates are
stored in variables.   I have specified those variables ...

I need help...in my report I am trying to get the total of accidents that
happen in a department. For example I have 43 department in my report I need
to show that the Road Department has 3 accidents....how can this be done.
Thanks

lets try this again.
want to use > formating in a field with 5 digits but I only want to use last
2 digits to base the formating on. what charactor can I use to allow
formating to use only last 2 numbers?

Access xp sp3
Mostly I create reports by hand, but when I recently used a report wizard to
genreate several, the text boxes and their labels it generated are out of
alignment! The text in the text boxes sits higher than the text in the labels

I developed a tax receipting application for some charitable groups and I've
noticed that on some HP Deskjet type printers the jpeg logo does not print if
the printer is set to Draft quality. It prints normally when the print
setting is overridden to Normal or High quality ...

Access 2003
I would like to insert the database filename w/path in the footer of a report.

I'm exporting Access 2003 reports to Rtf files. Everything is working fine
except one blank line is getting inserted at the end of each page. I don't
want the blank line to appear at the end of each page as I'm copying
formatted data to Excel that is expecting data without any ...

How do you stop the "Pring Macro Definitions" dialog box from appearing when
printing reports from a macro?

i am attempting to overwrite existing snp. files from an access database.  I
receive a dialog box stating "file xyz.snp already exists, do you want to
replace the existing file?"  There are "yes" and "no" buttons to select.  I
would like these boxes to not appear and the file to ...

I am trying to make a report that would print price tags for items.  I need
the number of tags printed to be dependent on the field "Quantity."  
Therefore, if we have 3 chairs and 1 table on hand it will print 3 tags for
chairs and 1 tag for the table.

I have a report who list data groups by Machine platform (Windows,
Unix, Central, etc.), Server and Security Priviledge.
But when the platform is equal to Central, i don't want to display the
server label and his value.

Does anyone know how to trigger a report to print as many times as a value in
a textbox.
I would need to use this in a ticketing system.
eg. a group buys 8 tickets, i create one line item and change the quantity

I need to make a report to send car brochure's out from Access. In the main
body of the letter the model of the car is used several times. Is it possible
to have this included in the mass of text like you would in VB code ie:
"Here is your brochure for a " & CarModel & "."