Can you create a field that will look up the id of a record in the same
table?  For instance, a table of employees, with the SupervisorID as a field
so that it would reflect the id of the supervisor, but the supervisor is
also an employee.  Or should I create 2 separate tables that ...

Access 2000
Is it possible--or wise--to use the AutoNumber data type for the primary
key?  I seem to remember reading that it's not a good idea but I didn't
fully understand why.  Can anyone explain this to me?

Access 2000
I've been working on a small flashcards database as a learning project.  I
have the following 2 tables:
Side A - Contains the text for side A of the flashcard.

Hi ;
I could use a tip here. I need to convert a Excel
spreadsheet, single page, 10 fields, approx 700 records
into a MS Access standalone database... as if I had typed

Access 2002.  This error just started happening.  It
happens with all my databases.  When a second person tries
to open one of my databases (.mdb), and another user has
it open they get the following error message:

I have a table that formats the phone number as !
\(999") "000\-0000;;_
Previously, this format was set to not place a space after
the area code, so I have many records in the table in this

I have a table with Contrac_Num, Company_Name and Fees
that are charged to that company by contract.  I have a
table with 124 codes for each type of fee.  They enter the
Contract_num, Company_name and Fee Code. I need to find

I have a date table that currently stores dates in a YYYYMMDD format.  The problem I am encountering is that when I go to extract the date via ASP, to be displayed, it is returned in the format MM/DD/YYYY.  The same issue exists whenever I click on the data inside my table.  Is ...

I'm having a strange problem with Access on my new PC, and
am hoping someone can help me out with it. When importing
a text file into Access as a new table, I have a weird
error during the import process that I can't figure out.

The feature that allows you type the first part of a
field entry and have Access display that entire entry
does not seem to be working.  Is there a setting that we
need to correct to make this wor?k.  Will be glad to

I'm designing a database to track information for child
abuse cases referred to a clinic. I need some help
relating tables.
The database will need to keep track of victims,

I have two tables, some of the fields are the same in
both tables.  I would like to create a table that shows
the common field, and which includes data from both
tables.  Any ideas?  Thanks!

How do I link a command button to an access report?

I have a date field. I want to link it to another date
field so when a date is entered in the first date field,
a date one month later is shown in the second date field.
Help much appreciated.

My task is as follows.
I have an Excel spreadsheet with data that I want to save
in an Access table.
Each row is a person, which will have a field e.g.