Summarize data by pay periods

[June7]

Can't use many functions in Calculated type field. Do calcs in queries or in textboxes.

[rpeare]

no, your table is only storing the date that you provided the service, not the pay period that it was provided in, and frankly there's no reason to go with that type of architecture. The report is going to show you a period based on what you enter, the default is to enter a start date and the end date is calculated, but you can overwrite that as well if you want to, for instance, report on a full month of data.

[breakingme10]

Is there a way to get my query for the driver name to show for the combo box as firstname lastname instead of the id # i unclicked the show on id but now it still just shows last name

[rpeare]

I don't understand what you are asking. The report is based on you putting in a starting date and nothing else. If you did as I suggested and made an employee table that had an ID with a first and last name fields you can concantenate them in a combo box with a formula like DriverName = Driver_FN & " " & Driver_LN

[breakingme10]

well, i need to print up the report at the end of each pay period and they want the exact dates the fuel was taken on, i think there are rumors floating around about over use of the gas so they want to know when and to what vehicle and then a separate report that shows when and by which driver

[breakingme10]

oh sorry i fixed my name issue earlier, i was entering new fuel cards in the database which is what my form was for and it would only let me choose the driver by id and i kept having to go back and look up their id. but all fixed on that

[breakingme10]

Ok so i have the tables and everything, now I just need to get the reports to be formatted like this for the driversort:



and like this for the unit sort: (yes they want two separate reports)


Here is my database so far:

FuelCardReportLog.zip

[rpeare]

So what's the question?

Are you having difficulty with the shading? the sorting/grouping? the subtotals?

[breakingme10]

the sorting and grouping i can't get it to sort right. i just need a report each pay period. the color coding doesn't really matter i was just trying to show the distinctions

[rpeare]

In both cases the date is your first sort

In the first report your second sort is last name, then first name, then unit

in the second report your second sort is unit, then last name, then first name

I would also work the employee ID in there to to create the right breaks (just in case you have two people with the same surname for example)

[breakingme10]

i guess my main problem is i don't need every single fuel card entry in the report only the entries for the two week pay period.

we do have brothers here so same surname is an issue that's why i did the driver name so it adds the two together for sorting purposes

[rpeare]

oops read wrong post as most recent

[rpeare]

that's why I said put in the employee ID as part of the sorting/grouping, then you can put the summary (the person's name) in the group header/footer of the employee ID and it will show as you want it.

[breakingme10]

but how can i get it to not report all the fuel cards just the ones between the dates in the payperiods query

[rpeare]

you put a criteria on the data that's running your report that encompasses your pay period.