Return Value?

[jdbit2byte]

I have a table that stores technician time entries for the work they perform.
The technicians are supposed to enter their work performed for each day. I
am wondering how to check the data that I have and return a report or form
that lists the technicians that did not turn in their time entries.
Tables:
tbl_Tech
TechID
TechFName
TechLName
tbl_Time
TechID
Date
JobNum
JobName
LHours
THours
etc....
Thanks,
Justin

 

[NetworkTrade]

well since no one else has replied - will just give one basic
approach.....essentially you could query on null (no entry) for a specific
field...

this does presume there is a record in the table , let's say the Tech Name &
Job No.......but that the column/field you are looking at i.e. Completed
field ....has no entry....

obviously there is no record in the first place one could not report that....

so presuming you create records at the start of day that enter all
jobs.....you could run a query at the end of day looking for null in one key
field...and the query will return those records for which that field is null.


Try putting Is Null as the criteria in the query design.....

 

[jdbit2byte]

Figured out a way around that. By passing the queryed data through two
queries the data needed was able to be bound to a report.
The first query's criteria is:
Day() -1
The secound is a Find Unmatched Query, it calls TechID from the Tech table
and TechID, TechName from the first query.
Criteria for the second query:
TechID from the first query - IsNull
The query then compares entries to the tech table to find which techs had no
entry yesterday.