working with ACCESS 97, can one table be inserted into
another as a subdatasheet? I've done this with newer
versions but don't see it here.
Thanks in advance.

I have a database that I am in the process of revamping.  
We call it Discrepant Material...We have parts that are
machined and messed-up, they need to be tracked so that we
know what the problems are on a part and who caused the

I am trying to append two tables together and I keep getting an invalid
arguement.  I have made sure that all the data types match and all headings
are the same.
I have appended several other tables to this same table.  It took me forever

I am trying to take a table in access from last year's data and copy the
format into a new table to be ready for this year's data.  How do I do this.

Table one contains fields with information on stocks. Example, field one is
StockSymbol, field two is StockName, field three is Exchange, etc. Overall
there are about 30 fields per record in Table one.
Table two contains portfolios for clients. Field one of Table two has

I`d like to relate two fields together so that when I choose one of them from
a lookup list, the other filed get the appropritaed predefined value.
For example If I choose "1", "Apple" Appears and If I choose "2", "Orange"
Appears.

Is it possible to calculate a default value and save it in
a table, I would like the default value in a table to be
the sum of two already entered fields. I could make a
query that calculates this however I am not able to save

When a user enters from a dropdown list a specific number,
I would like that this number be used to make that number
of records in a table.
A box contains 'a number of items' (to be user defined)

I have a table that contains a column with percentages.  
When I setup the table, in Design View, I choose for the
percent column the following properties:
Data Type = Number

I am trying to create a new table but keep getting
the 'invalid argument' error. I cannot see anything wrong
with my design...what am I missing?

trying to find the trefoil symbol that represents Girl Guides Association

I have a table called orders and in that table i have a field called Date
Shipped, and its value has to be one week from todays date.

I have two tables.  the first one has many fields but
three of them are first name, last name and
contributions.  the first  and last name is populated in
the table and the contributions is blank.  The second

I need some help. I have this in one field 040923131500 which is
yymmddhhmmss. This is imported for a text file. I would like to move it to
two fields.
mmddyy and hhmmss.

I just  created my DB and and within this DB I also created a switchboard
for user simplicity.I have my master copy on my machine, i draged and dropped
the FE on each users folder on the network then placed it on their desktop
from their folder and linked it to the one shared ...