empty fields in multiple table query

[Vance]

Hello (re: MSAccess 2003)
I have different types of employees making notes about problem conditions
everyday. I have set up a form for each "type" of employee (service,
administrative, custodial, etc) each form with its own separate table (almost
all of the tables have the same fields).

The principal table is "Staff" with EmployeeID, FName, MI, LName,
DOB,SSN,etc. and the other tables (service, administrative, custodial, etc)
are joined one-to-many on the EmployeeID.

I can import each employee's problem entry from their respective forms into
the Master form (which gives an overview of the day) when the data is
complete. But, when one or more employees has no entry for a given day (out
of town, on assignment, out sick, etc), the Query then does not generate a
"row."

Is there a formula (or something else) I can put in the EmployeeID field
(for any given "type" of employee) so that if it is blank for a given day,
the Query will still run and generate the other employee's input into the
Master form? I'm limited in my coding ability but am game for most anything
at this point.

Thank you, Vance

 

[JohnFol]

Yes, change the link between the two tables in the query. Double click the
line and choose

"Include all records from 'Staff' and only those trecords from 'other table
name' where joined fields are equal."

..