Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

record not submitted

Status
Not open for further replies.
Samulayo

Samulayo

Programmer
Aug 13, 2002
46
0
0
GB
Hello all,

I have two queries called active and timesheet, which shows the current active personnel and a list of all accepted timesheets respectively.
I would like to be able to produce a query/report that would show a list of all active personnel who have not submitted a timesheet for a certain week number.
I am using access 97 in order to complete this task. Any help would be greatly appreciated

Regards

Samulayo
 
Status
Not open for further replies.

Similar threads

JimStrand
  • Locked
  • Question
Crosstab query - returning 1 record per week instead of 1 record
Replies
1
Views
128
JimStrand
JimStrand
TrekBiker
  • Locked
  • Question
Records in one table not in another 1
Replies
3
Views
78
Andrzejek
Andrzejek
datajockey123
  • Question
Note / Information box with date and time stamp for each entery
Replies
2
Views
145
dhookom
dhookom
TheresAlwaysAWay
  • Locked
  • Question
Can not get Access 2016 queries to accept form value input or TempVars! input 2
2
Replies
21
Views
211
TheresAlwaysAWay
TheresAlwaysAWay
MDGarcia
  • Locked
  • Question
Error Could not delete from specified tables 2
Replies
14
Views
202
MDGarcia
MDGarcia

Part and Inventory Search

Sponsor

Back
Top