Hi, I was wondering if anyone could give me some insight on the average
formula in Access 2007.
I'm trying to set-up some sort of database for the company I work for and
I'm having trouble with one part of the set-up. I need to create something to

I will be updating my system to either Windows XP or Vista and I need to save
my e-mail folders before I wipe everything out.  I don't know what data base
they are stored in.  What else should I be saving before the upgrade?
By the way I'm doing this because my Outlook Express ...

Is anyone using (or have you used) Access 97 under Win XP 64-bit OS?
If so, are there any issues, particularly in a multi user environment
where some users will be upgraded to XP 64-bit, while most stay with
XP 32-bit?

I have a current validation rule for a TEXT data type that is: Is Null Or
Like "??????" (so the user must enter 6 characters, which will always be
mixed between numerals and alpha characters).
How can I change this to have all of the alpha characters automatically

I have a database that I am trying to calculate the time (in days minus
weekends and holidays) between the Original Date and the current date.
I'm not sure if this needs to be placed on the form, query or add a couple
of fields to the report but this is what I am trying to ...

I have a control where we need the value to be formatted as follows:
Maximum of 8 characters (but could be just one i.e. anything from 1-8)
Can be either letter or digit
No spaces between characters

I recently downloaded the Pictures2K MDB and I applied it to my pictures and
it works fine in the forms!
However the moment I preview it in a report some pictures get loaded onto
the report and some DON,T (please note that all items have their respective

My query BAXSaver Canada has 4224 line of data. I'm trying to creat another
query change changes my 4 to 3, but I'm getting back fewer lines (3734). Why?
IIf([BAXSaver Canada]![Field3]=4,3,[BAXSaver Canada]![Field3])

Any idea how to search in an access table for fields that contain the # or
the * charactrs ?
It defaults to giving me all numbers if i search for # and fields with any
text if i put the *.

I have a Access 2007 database we are about to deploy as a stand alone.  On
PC's this is easy, but I have more than a few MAC's that are going to need
this app.  It is my understanding that they will need to be running either XP
or Vista for this to run for them? Am I  correct?  ...

Help!
I have a form (Quote form).  I have two vendors bidding on one job.  My form
has two columns--one for each vendor.  The fields in the table are named
Vendor A-Sale Price

i try to send my resume but igot error? i need help please!

Our company will be upgrading from 2003 to 2007 in the fall.  We have a dozen
or so databases in wide use, some in 2000 format/some in 2003 format.  
Reading other posts it appears there is pretty good backward/forward
compatibility, but we'd really like to test that before D-Day. ...

I have a table that contains a project name for each record. These projects
can generate one or more publications. However, if I put them on the same
table and record, it is hard to query them and count the number of
publications by type or by status.

Hello experts,
Using Access ’03…
I have the following code attached to a form:
Private Sub cmd_Click()