I have a project table where employees enter their time they worked on a project. What I need is a query that will determine which dates each employee has not entered anything in. Or something that will notify them that there has not been any time entered for each specific date. Any suggestions would be greatly appreciated... thank you
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!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
I need a query to select dates that have not been used...
- Thread starter Jorgandr
- Start date
CharlesCook
Programmer
The way I do this "everyone who is not here raise your hand" kind of query is like this.
Select
A.Employee,
A.Date
From
Table A
Where
A.Date Not IN(Select
Date
From
Table B
Where
B.Employee = A.Employee)
The select in the IN() selects all the dates for the employee. The Where clause in the main query excludes them. CharlesCook.com
ADP - PeopleSoft
ReportSmith - Crystal Reports - SQR - Query
Reporting - Interfaces - Data Mining
Select
A.Employee,
A.Date
From
Table A
Where
A.Date Not IN(Select
Date
From
Table B
Where
B.Employee = A.Employee)
The select in the IN() selects all the dates for the employee. The Where clause in the main query excludes them. CharlesCook.com
ADP - PeopleSoft
ReportSmith - Crystal Reports - SQR - Query
Reporting - Interfaces - Data Mining
- Status
Similar threads
- Locked
- Question
