I need to change a number field to accept 2 decimal places.  However, my
existing field is a number field with data type Long Integer.  Do I need to
change this to single type field with a currency or fixed format?  Or, some
other data type field?  The number is not currency but ...

We are using MS Access 2003.  We just find that there is a MDB file that
hasn't been used for a number of years.
We would like to know is there any easy way to find out which version of MS
Access (Like Access 97 / Access 2.0) it is created ?

i am doing my ecdl and am finding difficulty wiht knowing what the
abbreviations in the buildt in functions are and what they stand for,(asc,
chr, chr$, format, format$,GUIDformstring, inStr,LCase,LCase$, Left, Left$
ect..)   can somwone please clarify for me? this would really ...

Access newbie here.  We've got a calligraphy organization with app. 450
members.  All the data (for the last several decades) is living in a
handwritten, spiral-bound notebook, about 6 inches thick <g>
We figure its time to get a grip on things and get our membership data into

I have Access 2003 on a Win XP Pro SP2 desktop (512 MB RAM) and SQL Server
2000 database (50,000 records).
I also have Access 2007 on a Vista Home Premium laptop (1 GB RAM); SQL
Server 2005 installed with identical db.

I have got a lot of good advice from this ACCESS Newsgroup, thank you very
much.
The company I am now working is now opening a new company, they are doing
the IT development now.

have Vista and cannot print attachments. Have used the advise as per help but
to no avail.

I am using a multi select form to select events to create a weekly report. I
use a start date and end query to populate the form. The form has a check box
that is will be available for each event. Once the selections are marked and
the report is created, I have a toggle button ...

Hi!  I'm trying to create an Access report that looks much like a mail
merge.  I've got a letter that needs to go to school districts (one
letter per district) that lists the schools in the district.  The
report will also contain mailing data - district name, administrator

I am not sure if this question is appropriate but.................
Does any one know where I could acquire a Zip code table (Zip city State)
and a state abr Table .  I hope I am not ut of bounds?
Thanks

I've imported about ten tables in Access 2003 from text files, with no
primary keys, but they are same exact design (structure) in all of them.
data maybe repeated with different values.
let's say xyz is in table 1 his income is $200

Mr. Sanderson,
   I was just wondering, does the book come in the bundle? I am still in
the process of calling to order my bundle, because the line has been busy
every time I called. I called the night of the 11th. I also called last

I have the other Microsoft Office 2003 programs, but I did not get Access. Is
there a way to get it now?

i run office 2003 work with access 2003.
i split the address in 2. number and address
ie number "213".address "ross str".and some of the numbers have are
alphanumeric ie "213A".question in design data type i cannot put numbers

I used to use Office XP but have upgraded to office 2007.  Where can i get an
order tracking database template from, which is similar to the one that came
with office XP