Summarize data by pay periods

[June7]

Here is one method http://www.datapigtechnologies.com/f...mtoreport.html

[breakingme10]

I'm sorry I haven't been using access very long I'm not sure how to do that. In property sheet on report would i do that through the control source?

[rpeare]

Yes, create a query for your report (instead of basing it on the table) and put in criteria (there's a line for it) of something

between [Enter the Start Date] and [Enter the end Date]

the user will be prompted for the start and end date of a pay period and your report can handle the sorting/grouping from there.

[breakingme10]

I am so sorry I am being so dumb. You are so patient I really appreciate it. I think I understand now. I have really only used Access for the databases and forms and never really needed it to create reports since I was previously just storing information. Thank you so much for your help.

[breakingme10]

Well I'm wrong again. I made a query for PayPeriods previously that calculated the EndDate from my StartDate (DateAdd('d',13,[StartDate])) worked perfectly. So I created a query using both the PayPeriod Query and the FuelCard table and can't seem to get it to list all records between the payperiod start and end dates. it keeps just giving me all records listed on the start date only.

[rpeare]

how about providing the SQL for the query you're building.

If you are trying to get data for the pay period between the startdate and the startdate + 13 days (so you only have to put in one variable then your criteria for the query would be:

between [Enter the Start Date] and dateadd("d", 13, [Enter the Start Date])

[breakingme10]

Fuel-Jan102014mdb (2).zip

Can you take a look? I have to be making this more difficult than it really is, I am constantly overthinking things.

EDIT: I just noticed you are Access 2003 so this is the mdb format

Fuel-Jan102014.zip

[breakingme10]

and of course as soon as i post that i get it! the query is working perfectly! i just need to make the report from the query now. THANK YOU SO MUCH!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

[breakingme10]

---

There is also another page but it only lets me post 5

[rpeare]

looks to me like you have extra space in your headers/footers that's forcing print things to print out, that would happen especially when you force page breaks as well.

You could also be printing a report that is wider than your margins so that the second page is actually the right edge of the first page. Look at your margins as defined in the report design and then look at the width of your report

For instance if you have a page width of 8.5 and your report width is 8.501 you'll be printing a second page that looks blank but it's just the right edge of your first page.

[breakingme10]

Property Sheet Report Width says 16" but it won't let me change it at all.

[ssanfu]

I was playing around with your dB. I made a few changes......
As rpeare advised, I changed some of your field names, removed the lookup fields and added queries and forms....

Feel free to ignore my changes... but maybe it will give you some ideas or help..

The dB is in A2010 format

[rpeare]

move your cursor to the right edge of the formatting area (it should have a bunch of little dots in the background that form a grid. Click and drag that edge as far as you can to the left. If you don't get it under your formatted area's required width (for instance under 8" if your page is 8.5x11 and your margins are .25) then you have something else in there that is using up width and the only thing to do is to click and drag a selection box over the entire right half of the report where your data IS NOT supposed to appear and see what it highlights, then delete/modify/resize as necessary to get your report's design area to the appropriate width.