I have a report named "invoice" which I print to an Acrobat pdf file.
In the "save as" dialog box for the pdf, the default file name is
"invoice.pdf".  I would like the report name to be picked up from a
field on the report called "invoiceno".    Each time I print the invoice

I have a text box that calculates a sum. When the sum is zero nothing
populates the text box. I would like a zero to populate the text box. How
would I do that?

I want to have an unbound text box that will sum the Field Redmond Yards
Poured by day. I have tried the following formula but with no result.
=Sum(Abs([tblyardsdate] Between Date() And Date())*[Yards Poured Redmond])
I believe it should be done with the day function but I a mnot ...

I have a report which lists people's attendance on a course per week (so I
have a line with a name and the number of sessions attended by that person).
I want to have a summary at the bottom of the page listing the number of
sessions followed by the number of people who recorded ...

I really don't know what the subject should be.
Hi Group
Access 2000 WinXPpro
I have one textbox on my report that is supposed to show the quantity of

I have a number of mailmerge documents where the related query requires
entry of the date ie [Enter Todays Date:].  In previous versions everything
worked OK but with Office XP when I try to set the mailmerge up, those
queries with the above statement do not appear. Without it they ...

I have two simple tables. The first is a customer table, the second is a
transaction table. All customers have an Account Balance in the Customer
Table but one of those customers does not have any transactions in the
Transaction Table. I am doing a report grouping on Customer ID ...

I would like to link to a Crystal Report from an Access form however I don't
know if this is possible.  Can anyone advise please?
I tried using the same method that is offered for Word and Excel files but
this didn't work - any advice would be most helpful.

I am having a problem creating a report that looks nice with pivot (or
crosstab) information.  I have looked at the crosstab.mdb sample that Duane
has recomended to several people, which is a very elegant solution I must
say.  However, I continue to have a little trouble.  My ...

How can I print and/or preview only the record that I need  for a member and
not the other members. when I create a cmd button to preview the report, i am
able to view the others as well.
this is what i have:

I have a report that i wish to print off that contains a logo.  I want to be
able to link to the logo rather than embed it as I have several logos that i
use and it is easier for me just to change the main logo.  For example i
want to link to C:\nm\store\mylogo.jpg  How can i do ...

I have a form for filtering a report, but the independent pulldown field
called tagnumber querie bassed on a textfield, but the text for example
TT-1101 is trim to TT, shown because i have bin asked for a parameter, if i
fill in TT-1101 the report is show the correct field

I have a report based on a query where a number of the data elements are
Nulls.  I would like to suppress the detail when certain conditions are
met, ie, certain fields are Null.  When I try to set
Detail.Visible = False, I get NOTHING printed for any record line.

Can anyone help with a way of programmatically determining if a specific
printer (in this case win2Pdf pdf creator) is installed on a Client machine,
before attempting to open a report?
The report in question is quite complex and can have hundreds of pictures in

I need to generate a graph covering a 12 month period (Jan - Dec). Often, no
data exists for one or more months; however, I need to show the month in the
X axis. Is there a way to do this?
Thanks.