Hello Access World Forums,

Since its my first post and I might be back here more i'll provide some backstory. So i'm an an incoming college freshman with no professional experience in anything except excel and lots of non-professional experience in Windows and PC hardware. I've been working at the family company doing filler work, however the entire company has labeled me as the go-to computer nerd and I've been getting the opportunity to learn lots of new things. One of those is Access 2007. I've basically been tasked with up keeping the company's production database, taking requests from the higher ups on things they need changed. I've been learning everything as I go and haven't had too much problem figuring out Access, but now I have one problem i'm stuck on, but I have a feeling the solution might be a very simple one i'm missing.

Ok so here is a sample report:
http://img36.imageshack.us/img36/8135/samplereport1.jpg

Now as you can see for some of the job numbers there are multiple entries. What I need to do is set up the table so that there is only one line per job number, and all the data from each entry is combined into one line:

http://img32.imageshack.us/img32/24/samplereport2.jpg

And here is how its set up in design view:

http://img20.imageshack.us/img20/7772/report3.jpg


Hopefully this has been enough information for someone out there to be able to offer some help. If any other info on the setup is needed feel free to ask.

Thanks.

Hi,
What you need to do is change the recordsource of the report and not the actual report.

Firstly take a copy of the report for backup.

Now try this:
1. Open the report in design view.
2. Open the properties window and click on the data tab.
3. Click on Record Source and then click on the little box at the right with 3 dots on it - this opens the query behind the report.
4. Click totals (looks like an E - on the toolbar) to group the information.
5. In each column where it says GroupBy change it to Sum except for the Job Number column, leave this as Group By.
6. Click Run (the exclamation mark on the toolbar) to see the results.

Let me know how you get on.
Regards
JD