I have set up a form that returns the results of a query
based on user's input.  However, now I need to have the
query somehow search for the data in two separate, but
similar tables.  How does the query work for this type of

I'm a novice to database design and would appreciate if
any one can solve this.
I will like to ask if I have a superclass called Complaint
and several subclass like Quality, Handling and so on, how

Is there really any reason to use an auto number for the
primary key if you already have a field that would serve
adequately as a primary key?
I understand there is a DLookup function that I could use

Can you build a 3-dimentional table in Access.
I need a look-up table that is based on 3 pieces of information.

I am trying to create a simple database for printers and
cartridges. What I want to do is track the dates when I
replace the cartridges.  I want to continually add new
dates into the same field WITHOUT overriding but adding to

I know the routine for entering a zip and having it "find"
the appropriate city and state from a separate table.  
That's the easy part.
But how do you handle the fact that some zip codes are

One of my co-workers was manually editing a database.  
Now when she opens the DB, it shows as read-only.  
Someone told me to reindex the database.  How do you do
this?  TIA.

Is there any way to export a report to Word with the
complete formatting, such as letterhaed and table borders?
If not - is there any way to export it into a customized
Word template?

I have a table with a field called [Rate]. It is formatted
as a fixed number with 5 decimal places. Everytime I enter
a number, it automatically rounds the number to the next
highest or lowest digit. I would like it to not round off.

the area codes in my telephone field will always be the same.
is it possible for it to automaticly enter.
I have tried changingthe input mask. and it seems to work while
entering data directly to the table.

i want to capitalize first letter of each word in my table.  does this go in the input mask and how do i write it

i found out that my database few tables deleted
automatically. why ?
i am calling this acccess 2000 database using my vb
application.there is no code written to drop the table

I am creating a database of 34 camps.  Each camp has a
limited number of individuals it can accept.  I want to
preset a maximum number of records for each camp.  So say
if a camp can only take 50 people, I want on the 51st

Hi,
I have an Access 2k app I am deploying which has a front
end backend design, but there are some "local" back end
tables that sit on the users workstation.  All of the

I am quite new to Access and I cant figure out how I can have a field in at table that have at short text and then a autonumber. I would use this for a primary key and the field should have the two first letter og the surname, then a "-" and a 4 digit autonumber at the end. So ...