Recent content by jackiem

Hi ! Hope someone here can help me. I love this forum! I have a db that runs great on my computer but several reports will not work on other users in the office. It gives them an error. When I sat at another computer to examine the problem, I cannot do expressions in the query for those...

With this criteria you are assuming I need the hours for the last 7 days from today. This is what I need: Driver: John Doe Date Hrs Driving (Result) Last 7 days 9/1/03 0 0 9/2/03 5 5...

I realize that but my question is really, How do I tell it to Sum the last 7 days from that date (not today). Do you understand?

I have a table which logs driver hours using clock in/out input. The total hrs each day are calculated in a query. I need to do the following: 1. Calculate total hrs last 7 days 2. Calculate total hrs last 6 days 3. Calculate hrs avail tomorrow (1 & 2 - 70) I need these to list sequentially in...

Please help! I have a table which contains truck driver logs. It records the hours worked by each driver each day by recording their clock in/out times. A query puts these clock hours into 1/4 hr totals. My delimma is that I need the calculate the total hrs. worked: 1. the last 6 days 2. the...