I have a report and I want the Invoice Number to be of the format W0400001
where "W" is a fixed alphabet, 04 is the year 2004 and 00001 is auto-number
field. My questions:
1. How do I extract the last 2 digits of the year from any field of the

Hi Group,
I am having problems calculating an overall 'total' figure
on my main report (rptFarmerDetails).  I have 6
subforms/subreports on my report and each

Im using access 2000 and i need to send a report via e-
mail. I have worked out how to send it as an attachment
using the SendObject macro command but i need to send it
as the body of the e-mail if possible instead of as the

I read the article written at the following URL.
(http://office.microsoft.com/en-
us/assistance/HA011170771033.aspx)  However, I am having
a little problem.  I am attempting to use this

I've the following code running in the Detail Format section of my report.
It'll insert a page break when the [Day] field increments by 1. When i scroll
through the pages of my report the first time (in Print Preview), the code
runs and page breaks are inserted properly. Then i ...

Duane,
I posted a message yesterday, to which you responded that crosstab reports
would be worthwhile checking out.  You posted a link to a sample crosstab
report db, but unfortunately, I can't open the database.  It looks like I

How would I go about counting the records on a report and displaying that number at the end of the report??
Thanks

OK, I've searched the groups and probably looked at a few examples here and
there, but just can't seem to find the right answer.  I have a report built
from a query that will print out a listing, grouped by SHOPS.  Within each
SHOPS group, there is a column called TSC.  The ...

I can't get the page heading of the subreport to print on
the main report.

How can I make sure a particular report always prints in
landscape orientation? Something in the On Open event?

This subject may be out there but I haven't come across
it yet.
I am using the "Contacts Management" database downloaded
from the MS website w/ templates.  I have added an

I have a report with a date parameter.  Regardless of what I put in, I get
the exact same string in my report.  I like the idea of allowing users to
enter "11/2/04" or "11-2-2004".  However, I would prefer that Access
converted the date to the regional settings in Windows before ...

When printing a report Access(2k) does not give me the
option to specify the number of pages I want to print. Is
there some setting I can change to allow me to do that?
Thanks for the assistance.

Access 2003 + sp1.
Now this.
I have a report whit group/detail sections. I need to print only ONE blank
line when a certain condition occurs in the detail section.

If, for example, I have a report which contains details of
100 indivuals, with each persons details on a seperate
page.  How do I output this report to form individual pdf
files for each page, the name of which is the name of the