Acces Report Query

[nateDiggs]

I have a table that contains software usage records. It has the name of the software package, the computer name with it installed, the budget code that the computer belongs to, and the name of their area. I want a report that does this:
Lists each software title with the names of the 4 areas with totals in it. So basically:

Adobe Acrobat
Area 1: 240
Area 2: 150
Area 3: 100
Area 4: 225
Software item 2
Area 1:.....
and so on. How would I go about doing this? I can't seem to figure it out. Any help would be appreciated.

 

[ddiamond]

There is a little dot in the upper left hand corner of the report. If you right click on it, you will get a popup menu. Click on the "Soring and Grouping" menu item. Enter software package as a group head. Next you need to add a group header to the report. Put the Software Package in the group header. Put the rest of the information in the group detail.

 

[nateDiggs]

This is what I tried. This is not what I want though because if I do that it displays each record with the individual software titles. All I want it totals information for each software title, not all the records associated with the software title.

 

[dhookom]

Can't you just hide the detail section of the report so all you see is the totals? Otherwise can you use a totals query as the record source of the report?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]