Timecard Form or Report? and How?
Posted on 2004-10-29
I'm needing a popup report/form that looks like a timecard. Showing ClockIN-LunchOUT-LunchIN-ClockOUT data for Sunday through Saturday.
I have a weeks records in the table and a query that pulls the information.
So far I've tried making a report... but it will only show data for the dates the employee clocked in. Meaning, if they were out on Wednesday, the report shows Sunday(if they worked) Monday(if they worked), Tuesday(if they worked), Skips Wednesday(if they didn't work), Thursday(if they worked), Friday(if they worked), Saturday(if they worked)
Another thing I didn't like is you don't have much control over the size of the report other than selecting different paper sizes.
I made the same report in a form. This is formatted much better because I can put all the fields I need on the form. So if they are out on Wednesday, the Wednesday ClockIN-LunchOUT-LunchIN-ClockOUT data fields should be blank.
The problem with the form is it's tied to the same query, but only shows data for the first record.
Is there a way to specify each textbox to pull it's data with a whereclause?
The textboxes for Monday should be use the data from the record where PayDate = PayPeriod-5
PayDate is the date the timeclock record was made.
PayPeriod is the date of the Saturday of the week.
I already have labels for Sunday, Monday, Tuesday, etc. that use =[PayPeriod]-6, =[PayPeriod]-5, =[PayPeriod]-4, etc.
Any ideas? or thoughts on the route I'm taking?