I have dates stored in a table field.  I can extract just the day fine.  For
example, if I have 2/5/04 stored.  I can extract the day 5.
Is there a way I can extract and then print on a report the proper extension
to the number that is 1st, 2nd, 3rd, 4th, 5th, etc?

I'm trying to e mail 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
get an attachment instead of one attachment showing all pages.

Trying to design a report and want to group records together based on
age range.  Is this possible.  Fairly new to Access and would
appreciate any help someone could provide.
Aj.

I use an access application that checks for the status of a license such as
active and inactive. I need to exclude the inactive records from printing in
reports.
Can anyone provide a sample query or macro to do this?

If I do not have a record counter can I get a total number of records in a
given year.

I need to have a Total of my controls on sub-report at the location of
footer of Main report. I tried hard, but any reference to sub-report is shown
as error.
Could anyone help me to make it??

i have a subreport that will have a column layout for a subform. I am having
a problem with the down and then across. I have a list that on the 11th line
it will start to list on the 2nd column, so column 2 would start at item 12
and so on down.  On the Subreport everything looks ...

I have a database where is store pictures using OLE. Now when the user
inserts the picture the size of the image becomes very small, smaller than a
thumbnail. Now my client wants the picture to be big. I tried increasing the
size but the size of the OLE field increases but not ...

I plan to create a report based upon a form with a memofiedl.
This memofield can contain 1 word or 20 lines of text.
How should I create the report so it only takes as much place as needed,
nothing more, nothing less.

I have two databases and have a command button set to preview reports in
each database.
When I click the preview button, the report will display over the form in
one database, but behind the form in the other. I want the report to appear

Is it possible to email multiple reports in one message?  If so, how?

When using Word how can I insert a line at the top?

I have a 1 page report which I want to print numerous copies of.  The number
of copies will be specified by the user.  My problem is that I want each
report to print the copy number of number of copies, e.g. 1 of 6.  I can set
the report so the report prompts the user for the copy ...

Is there a way to scan MS Access report objects for text instead of looking
through each one?

I've built a report using a aggregate query that is grouped by Month +
Year, Program and Name.  When I feed the date ranges as query
parameters, it will very properly print out a report that shows a
separate page for each program by month with the names of the folks in