Here is the revised table structure for my scheduling database.  I need to produce
<print out> a 2-week pay period schedule for approx. 18 employees over a 24-hour
work day.  Mostly 12 hour shifts, with up to 5 people starting at one time - the rest start
at staggered time ...

Anybody got advise on how I can set up price bands.
Let me explain: in an order entry form a quantity of 1 is entered for a
product, the price each will then display the price given for that product.
If the quantity happened to be 10 the price each would be different to

I would like to ask for your wonderful help in determining what method I
should use to guarantee the uniqueness of the data being imported into an
Access 2002 database on Windows XP. The data file is downloaded as CSV text
file with 40 fields defined. The source provide states that ...

Help, I was inputting some data in one of my forms when suddenly I got an
error and the record was basically turned to fields with little 'squares'
and when i go into the table it will not let me delete it and gives an error
of "The Search key cannot be found in any record!"  when i ...

Hi - Have an mdb with [tblApp] to store applicant records.
The PK is autonumber AppID - AppID has a 1:M relation with many other
tables.
Other fields in [tblApp] i'm concerned with are

Here is my question:
I have a main table that contains the complete contact
information for each stakeholder.  This includes: name,
address, city, state, zip, phone, etc... What I need to

Greetings, here is my problem:
I have a table with a Primary_ID field, whose numbers I
wish to retain for historical purposes.
I wish to convert this field into an AutoNumber field, so

How do you get the time stamp included with the Date?  I
know that =Date() defaults the date, but what is the
function to add the time as well?
Thank you

 I've designed a table that stores hourly readings for a
24 hour period containing the current date and 24 fields
representing each hour. I'm trying to extract the Max
value over a 24 hour period. Can anyone please assist me

I want to divide the data in one column by the data in
another column and have the results posted in another
column.  Think it must be done in the design view but
have not been able to figure out the exact steps to make

I have a table which has an autonumber field and a date
field.  When a certain action is undertaken on a form,
the value in each of these fields is appended to
an 'archive' table and then deleted from the current

Good day!
Is their anyway a calendar object can pick up the system date in access
2002?
tia, mark

I am trying to build a database to store various
measurements of plants, done over a period of time.
I have a table for the plants, which specifies the
location of each plant and its identity.

I appreciate your interest in my question.  Here it is. I
created two tables and set them up as a one to one
relationship on a specific key.  When I try to add a
record to one table it complains about the record does

I have a very simple question!
I started out by creating a simple database for my
company to automate some administration tasks.
However, my database has grown to pratically a full