What is a good way to approach a "point in time" design
for a lookup table and its relation to a transaction table?
I have a Call table and an Employee table (I have more but
I think this will suffice for the purposes of explantion).

Is it possible to import pictures into a record of a
table?  I need to have 3 pictures per record...  Can I
import all 3 directly into a specific record or is there
another way to go about it?

I have one table and I am trying to get one field to show
a value based of the value of another field. Here is an
example..
I have a field named "Day" and a field named "Sunday

I have an Excel Spread sheet with 2 columns "No." & "Notes" both are
formatted as "text"
There are about 60 rows of data in the sheet all the info in A1:A58 = 260
A59 & A60 "by260".

I am supposed to create a validation rule to prevent the
input of data for customers less than 16 years of age
from today's date. How do I do this?

I created a database in Access 98 around 18months ago.
About 2 months ago I converted it across to Access 2000 - no
problem................... until last week.
Now, when I try to create a new record in the form - or the table - I get an

I am creating an access project for a teacher friend of mine who needs a
database to track his students assessment scores for the next six years.
What would be the best way to keep this info; one table for all six
years or one table per year?  I am also concerned with how the ...

I have a table with some data in it already, in one column I need to locate all dollar amounts of more than $0.00 and place an M there instead, and replace everything that is $0.00 with nothing - is there any way to do this.
Also I have another column with numbers like 24B, 24H, ...

I need in my database to create a list that will, in turn, affect the choices in another list.
An example will explain better
If I choose a state from one list that has been defined to hold only the 50 states, I would like another list to show only the counties within the ...

How do I use the lookupfunction and show two (or more) fields instead of only the first one. I would like to lookup Customer number and would like the "shown" value to be 2 fields, the Surname and the first name. Is this possible?
Jon

What is the maximun number of fields (columns) that can be
in an Access table?

I'm working on a service call database that is dependent
on tracking profit, loss and all activity by each machine
model and serial number.
We have to keep track of the following:

I want to be able to create a update wizard to update
queries,forms,reports,macros by a push of a button.  Can
I do this?

I would like to create a database to archive photo of product we sell. I use OLE Link field to photo file but it makes my database really big (photo are in JPG around 72 KB). Is there another way to create a photo database without having this DB beiing huge.
Thanks for your help

I have a field in an existing table which is formatted to
an autonumber field.  I am up to 16410 records and when I
try to generate the next record, instead of 16411, I am
getting a number like 1927871771.  Subsequent records