How do I connect 6 normalized (3NF) tables which were one table?
I have split a large table into six.  The main form has been reduced in
size and keeps its "mainID" autonumber.  The other five tables all
relate to the original table.  I kept "mainID" in the other five tables

Does anyone have a database that would calculate the hourly employee time?  
Is this feasible in Access?
Thanks!

I really tried to not post this question but I gave up.  I tried brackets,
parenth...etc but nothing worked.  I get this error message: Incorrect syntax
near the keyword 'THEN'.  Please help, I am learning SQL Server.
thanks in advance.

My question is:
I have a timesheet form that contains my depts employees timelog.  One of the
fields is employeeID.
I've created a switchboard where the employee clicks on a command button and

Anyone have a way of adding additional fields to a BE database that has been
deployed to a number of users.
I have no problem creating a copy of the data to temptables, but need to
when I try to do a make table. As my current process  I get an error as the

A few of the queries/reports in my newly created database run very, very slow.
Often up to 15 seconds after a command.  Not only running the queries/reports,
but making design changes also.  The only common theme I can identify would
be that these are pulling data from externally ...

I am trying to build a database and want to stop incorrect dates being
entered by getting users to click on a date from a calendar. I only want the
calendar to appear when the date field is being updated as it takes up a lot
of screen space. How do I get it to be hidden when I ...

To date I have mainly built small one off databases and a few split network
solutions (mde FE & mdb BE). I would like to start learning how to take
create deployable for users beyond my network. I understand that ADE and VS
Tools have packaging wizards that deal to some extent with ...

My medical database incorporates all the ICD-9 (diagnosis) and CPT
(procedure) codes for the user to choose from and associate with individual
patients. Each list is thousands long and is organized based on a hierarchy
(chapter, section, subsection, etc.) I am trying to figure ...

I have a database that, until today, was displaying pictures in an image
field linked to jpg files.  Today, I am getting error messages saying that
Acess does not support jpg files.  I had to re-install Office so I am
wondering if there is a reference I am missing or what has ...

I am updating an Access database created by a former employee that we use to
track employee training as part of ISO, using ACCESS 2002-2003.  
When a WI/PRO is updated it is entered into the database incrementing the
revision level by 1 (Assy-010-01 would become Assy-010-02).  

I have a quoation table that is linked to a quoation details table. I then
have a form with a quoation table main form and quation details subform. This
subform contains three fields, all of which are controlled by the RTF2
ActiveX control so that words can be individually ...

My database consists of three main tables: one for the data which contains
only an item key, a date, and a value for each record; another for the item
keys, which has descriptions and details of the items in the data table; and
a third to give details on data sets that consist of ...

Does anyone have a attendence database to track attentence?

I have a mainform which the user enters records into the tblevents and a
subform which enters records into tblinvoice.  Although the relationship
between the tables is one to one, multiple rows appear in the tabular subform
for a user to enter more than one record.  Then of ...