March 26th, 2010, 06:41 PM
posted to microsoft.public.access.gettingstarted
|
|
|
Gathering information
"KenSheridan via AccessMonster.com" wrote:
Whatever the final output format, start with a query which joins the two
tables on the First Name columns. If the Pass/Fail column is a Boolean
(Yes/No) data type enter False in the criteria row of this column in query
design view; if it’s a text data type with values ‘Pass’ or ‘Fail’ enter Fail
in the criteria row. Having created the query you can base a form and/or
report on it.
However, using the First Name columns as the keys is not a good idea. Names
can be duplicated, so are unsuitable as keys. Give the first table an
autonumber primary key column such as EmployeeID and add a long integer
number (not an autonumber this time) EmployeeID column to the second table as
a foreign key to the second table. The tables can then be related on the
EmployeeID columns and employees with the same name(s) can be accommodated (I
worked with two Maggie Taylors once). The redundant First Name column in the
second table can then be deleted.
Ken Sheridan
Stafford, England
kmr wrote:
I have an end result in mind, but I just cannot figure out the best way to
get to this result. I have a database on staff and drills performed. One
table has staff first and last names. A second table has the first name (a
relationship linking this table's first name to the first table's first
name), date, station, time to ID, pass/fail, and observer. From the
information I have entered, I want to make a list of all staff who have
failed a drill. I have one column for pass and fail, so how to I create
something so that it pulls only the fails from that column? Do I use a
query, form, or report for this?
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...arted/201003/1
.
|