Timesheet access Project

[aucho22]

Hi GinaWhipp,

Thank you so much again I managed to modify the query so that only the names (grouped by) and the columns for regular hours, overtime 1,5 and 2 appear.

Now I just need to figure out why when I create the report, it is asking me twice for the start/end date

Crosstab queries seem to be quite handy, I need to do some digging...

Thank you again, O access magician.

 

[GinaWhipp]

You're welcome!

As for the prompt, there is a button called Parameters when in Design View of the query, click it and erase what you see there. This may be of some help...
http://office.microsoft.com/en-us/a...r-input-when-running-a-query-HA102809759.aspx