W
WAstarita
I have a payroll application that requires the end users to know if all
neccessary time sheets have been entered.
Basically, there is an employee table. In the employee table there are
7 (Day) fields (Monday, Tuesday, Wednsday, Thursday, ect)
We pay bi-weekly so I have to created a query against the employee
record to generate a table of dates within the 2 week time span.
This table is then checked against the time sheets table per employee
to see what days timesheets were not entered for that employee.
Right now, I have to update a table I created just to house the valid
dates in ADO then insert the query into another query through ado to
return the recordset. I would like to just be able to created on SQL
query that does all of it.
Is there any syntax to lookup information in an inline format. For
example
Select DateWorked From TimeSheets, (Select VaildDates: 10/7/2006,
10/8/2008, 10/9/2009, ect), join Vaild Dates on TimeSheets.DateWorked,
.......
I know this is kind of vague but without any concept of where to start
I cannot show any demo code.
Thanks in advance.
neccessary time sheets have been entered.
Basically, there is an employee table. In the employee table there are
7 (Day) fields (Monday, Tuesday, Wednsday, Thursday, ect)
We pay bi-weekly so I have to created a query against the employee
record to generate a table of dates within the 2 week time span.
This table is then checked against the time sheets table per employee
to see what days timesheets were not entered for that employee.
Right now, I have to update a table I created just to house the valid
dates in ADO then insert the query into another query through ado to
return the recordset. I would like to just be able to created on SQL
query that does all of it.
Is there any syntax to lookup information in an inline format. For
example
Select DateWorked From TimeSheets, (Select VaildDates: 10/7/2006,
10/8/2008, 10/9/2009, ect), join Vaild Dates on TimeSheets.DateWorked,
.......
I know this is kind of vague but without any concept of where to start
I cannot show any demo code.
Thanks in advance.