Hello,
I am looking for a way to query a table for the "latest workdate".
The table fields would be: Project, Task (T1,T2,T3,etc) and
workdate. Within each project different tasks are worked upon at
different dates and each task may have many workdates associated with
it. I do not use access much and I am a novice with it. Much more
familiar with excel. I tried the expression builder using the maximum
function but could not get the results I need.
Re: Query A Table For The "latest workdate". ... The data is in the correct format and I did ... I have a 4th field column - Employee.... You can use a normalizing union query to get the data into the correct form ... and then use that query to get the latest workdate for each project. ... (microsoft.public.access.queries)
Re: Query A Table For The "latest workdate". ... TaskDate - Contains the date relevant to the taskType.... You can use a normalizing union query to get the data into the correct form ... and then use that query to get the latest workdate for each project. ... SELECT Project, "Task 1" as TaskName, Task1 as TaskDate... (microsoft.public.access.queries)
Re: Sum Query on Date and Time Fields ... Looks like a simple totals query to me. ... SELECT WorkDate, WorkTime, Sumas CountMen, Sumas CountTrucks ... WHERE WorkDate Between Dateand Date+7 ... (microsoft.public.access.queries)
Re: simple time sheet input bi-weekly ... Each day of the week based on the pay period number and year within ... a Query left joining this table to your timesheet table, by workdate....(txtPayPeriod), and create a Query joining this new table to your timesheet ... (microsoft.public.access.forms)
Re: Query A Table For The "latest workdate". ... I have a 4th field column - Employee.... Or do you have multiple task fields T1, T2, etc. with the workdate?...Task1 - contains date of Task1 ... You can use a normalizing union query to get the data into the correct form ... (microsoft.public.access.queries)
