I need to automatically have the name of a State abbreviated to 2 letters,
even if the full name is typed in.

I have an ERP system that we are converting over to a non-compatible system
(aren't they always?).  Basically, we are a manufacturing site with product
formulations, qc specifications, etc.
Because the systems are incompatible with each other, and only certain

I have a application (acc2k) that is used by a number of different
customers. There are a couple of standard letters available to the
customers but all have the same text and i am now being asked to
provide the functionality that will enable them to provide their own

Does anyone know how I can export a report generated by Access 2003 into pdf
format or any format that  preserve the report format. I know Snapshot format
is an option but some of the receipients do not have this application. So is
there another format I can export the report to ...

Hi Groupies:
I have a report that lists employee pay. The report is currently grouped by
week and then by employee.
Everything works fine, except that I would like the Date Header label to be:

We recently upgraded an Access 2000 database to Access 2003.  There
are over 100 reports that were designed to use the 'default printer'.
We have customers in UK and AU that use the A4 paper size as well as
customers in the US that use the Letter size.  In Access 2000 when you

How Do you create a master report on which the sizes for future reports are
based on?
To avoid a need to constantly tinker with the properties when the report
causes overlaps due to size differences?

I have a subreport with an underlying query that sorts in ascending
order. The subreport also has a text box with the following control
source:
="Facility ID/Line ID: "+IIf([Forms]!

Could you please tell me how to study system administration in MSAccess.
Tell me about a site too.

My report information is grouped by month. I would like to have the months
listed like this "January, February, March, April........December".
If I use Ascending option, the list will stat form A to Z Or
If I use Descending option, the list will star form Z to A.

I have a running sum in my report that is formatted as a short time. Once the
sum becomes greater that 24:00, it resets to zero.
How can I display 25:37 in my report?
Thanks,

I have a report that is just doing calculations in the footer.  The group is
based on a program.
Every footer counts, averages etc each program.
I can not seem to figure out how to do a min and max based on another field:

I am new to the whole Access thing and I have been trawling for hours trying
to find a solution, but to no avail. Hopefully someone here can assist me.
It's a bit longwinded so I shall try and make it as simple as possible.
I have been asked to produce a report from a stock ...

I have a main report and 12 unbound subreports. They all use the same 2
parameters. [Month] & [Year]. I would like to only have to enter the month
and year once and have it pass to all the queries. I tried to see if there
was another posting that fit, but nothing seemed to be the ...

I have made a db with several reports but when I open up the reports for
viewing,
they are showing up in a much to little window. I almost always have to
ajust the report