I am working on a project where multiple people need to keep track of how
many customers they serve on a daily basis.  Each customer can be counted
only once and must go into only one of 15 categories.
What I have thought of so far is to have an individual table for each of my

I need to determine the best way to take a database in Access 2000 and
enable 7 field operaters to update infomation in the field and then have
their updates entered into the master database in the office.
The database has a master table with customer data and each field operator

I have 2 tables with the same numbers of fields and same name
Table 1 is the original data and
Table 2 is the adjustments data, which needs to be kept seperate
I am having trouble combining data from both tables. In some instances there

Hi Experts,
I would like to know which system table can I look for the fields of each
table? In other words, by using the function in Access to run the Documenter,
we are able to generate the database schema, so I would like to know where

How do I get around the 255 character limit in text fields?

If anyone can help me I appreciate it. I am creating a new database, and I
want to set up some equations that will automatically take place when I imput
the money value.

I suddenly have this "Unread Mail" folder.  New mail cannot be opened from
the "Inbox" anymore, even though there's a blue # telling me how many mails
are there.  The same # appears at the "Unread Mail" folder, and I can open
that one just fine.  The problem occurs when I'm ...

What is the proper naming convention for naming fields?  Some people
will use underscores between the key words, some just use caps.  I
believe that you also should not us spaces. Is that correct?  What about
for table names and such?  Does the same practice apply?

I have created a report that uses the counting procedure, now I need to total
that procedure.
I also need to know how to save the program to a CD so that it can be
transferred to another computer. When I do the transfer it comes up as Read

Sometimes users input incorrect data or delete records by mistake.
Correcting these may be tedious; especially if they aren't immediately
detected. Therefore, I want to provide means to detect and correct such
errors.

Please Help! (Working in Access 2000 file format)
Scenario: The store gets invoices. The main office processes invoices. I
want to find out three things-
1) the invoices the main office processed that the store received.

Is it possible to decrease the size of a text below 8 with Word?Please help
because i am mad already!

My Access97 database is linked to an Excel97 doc. How do I change field size
in my linked table?
Several records contain data bigger than 255 yet Access sets the field size
to "text".

This has got to be something that people do all the time, but I'm having a
lot of trouble finding examples.
I have two situations in which I would like to give people a fairly
elaborate set of options to choose from:

Is it possible to decrease the size of a text below 8 with Word?Please help
because i am mad already!