Search results

Thanks guys, I will pass on your concern to my brother in law.

My brother in law has a timesheet issue that I am hoping to help him with using msAccess. I am having trouble thinking through the structure so I thought maybe I could type it out here and see if anyone has any ideas. Each employee works three 12 hour days the first week and one 8 hour day...

This works Great!!! Thank you everyone for the help. I might try get the query alternative to work since it will be faster. thanks again

sorry for the typo in the original, I edited now. GroupName should have been resource.

Resource is a text field. I am getting an Enter Parameter Value on the FromDate and ToDate field.

I would like a query or expression that will lookup a rate for a specific resource based on a date range. Table 1 is TblDirectRates with the following fields: Resource FromDate ToDate Rate Query 2 is ETCHRs resoource Datefield Hrs I would like a to add a field to the ETChrs Query that...