I'm trying to e mail (outlook express) 2 reports from access 97 but find the
following.
1. I can't send both reports in one e mail.
2. One of the reports has several pages and for each page of that report I

I don't know if I did this correctly. I have two reports which run off of
queries that require a date to be given when the query is ran. One report has
two queries and both need a date inputed in. So that means everytime a user
wants to open the report they have to put in the ...

I have 3 columns of data. Some of the fields have a null value.  I would like
to add a 4th column which will be the total of the three columns.
       EXPR1               EXPR2             EXPR3             Total
          0                     5,465              2500

I need to delete the trailing space in a report after CITY  (i.e. City,
State, Zip) for a report.  I have tried TRIM([CITY]) but it is not working,
maybe I am putting it in the wrong place?...help!
Thanks!

Is there any way for me to sort a report by a calculated field that is on
the report footer?
Thanks,
D_K

I have a report that contains groups with headers and footers.  In the
report's footer, I wish to insert calculations based on specific records in
the report.  I can identify the records in the report's recordset by the
codes they contain.  Do I have to use DLookup function to ...

I certainly have an Access database with information related to several
employees.  The fields consist of the stard variables (name, position, hourly
rate, etc.).  I would like to convert this information to be automatically
reflected in a Statement of Works page created in MS ...

I want to be asked a question e.g. 'enter the nme of the person you are
looking for' and then when i enter the name a report is created showing the
information about the person whos name i entered (from the database).
I believe you can do this using a quiery?

Professionals:
I am trying to design a report from 2 tables. My report is based on a query
of the two tables.
Table 1: Company

Guys,
I'm creating reports but what I would like it to do it put the Filename on
the report too. The database I'm creating will be used to store data for W
month to X month. Then through copying the file and changing the name it will

I have a report that shows attendances.  I have instances of Present, Sick
and Absent.  I would like to count the instances of each one and have it
record the number on the report.  Is there anyway of doing this?

I have a report that I would like to print based on the current record on a
subform.  When I click the print button, I get a dialog asking the to record
number.  My code is as follows:
  Access.DoCmd.OpenReport "QFM7513-005A", acViewPreview, , "[ToolNum] = " &

How can I store the formatted text from for example Visual Basic into a memo
field and retrieve this in a report?

I've created a static report in Access (not related to any tables or
queries).  I try to export the report to Word and some of the labels get "cut
off" and displayed on page 2 of the Word document??
For example, the label box states "Pharmacy Admixture/Preparation

I run some code on start-up of our database to find some records that have
expired. We then create a report for these entries to send to our clients.
The report opens up fine in print preview but when we go to print a hard
copy It appears to spool (flashes now printing or ...