Can someone please tell me what is wrong with this:
=DLookUp("[SumOfManual Recall]","[ARLTTLCallbackMosaixQuery]","[Date]=#" &
[Date] & "#")
It is coming up Error on my report.  Thanks in advance for any help.

I am trying use a text box to calculate how many times the letter C appears
in another text box (with a running sum) and displaying it in yet another
text box.
Can anyone help?

I want to email out a report at a certain time everyday.  I set up a macro
that runs when the file is opened to export the snapshot report to outlook
and I set up the scheduled tasks to run when I want the report sent. All of
this works until after the snapshot is export to ...

I have report that was designed for one page.  On the  report I have a Labor
Hours Section and a Cost Summary Section.  I've drawn a line to separate the
two sections.  However, now there are some cases where the Cost Summary
section prints on the second page. When this happens, ...

I am using Access 2000.  I have a field on a report that returns a date 10/08/04 which is based on a query.  Is there a way to have the field display only as the name of the month in this report?  For example:  If  employee 2 on this report has the date 10/23/04, I want this ...

I want to perform a calculation in a report which divides the total number of
miles by the total time taken to travel them.  I am using the formula [total
miles]/[total time] where time is formatted at HoursandMinutes.  My result is
an error# message.

I like to print an address report in alphabetical sequence and would like
Access to generate a line number either in "report" format or as a "form" so
at the end I know how many name (line I have).

Hi
If Duane answers this, thanks for the prompt reply.
On searching the coding for the report (original message
below), I have found the following code:

Hi. I was asking the other day how to make a snapshot report a pdf. I finally
got that to work using a macro printing to Acrobat Writer driver, but now how
can I e-mail the saved pdf file?  I've tried "send object", but the file
doesn't get attached.  I'm not very good at VBA.

I have 5 similar reports showing information from the same query.  The
reports are generated in a Switchboard and the query is interactive with the
report.  In other words when I run the report the query asks for some of the
criteia.  Each report uses the same query, but each ...

Can I set a parameter in a report or do I have to make a parameter query and then base the report on the query.  I am wanting to make a report that only shows records between Jan 1 and Jan 31, or Feb 1 and Feb 29.  I also don't want the year to be taken into consideration but the ...

In the Page Footer, I have a textbox "txtPage" and its properties sheet
control source = "Page " & [Page] & " of " & [Pages]
But now, I have to add in language manipulation, if its the French language,
the " of" will be displayed as  " de" .  So, my control source will be

The Field for my SQL Statement Query Builder is E1: Left([Mnemonic],2)
When I have the Criteria as follows, it works fine:
Is Not Null And IIf([Forms]![boxStatusReport]![PrintOneOrAll]=3,"CL")
But if I want to check more values, like this:

How can I enter a formula in a group footer that will sum a footer subtotal,
plus a total reported in a subreport?

Is it possible to use an existing Word document as a report template instead
of creating a new one in Access?