Grouping and Sorting with Totals

[mgonzales]

I have a table that contains a few fields that I need to create a report by grouping and sorting fields in certian ways but I can't figure out how to do it. I think I need to create some type of query, but I cant get it right
The fields are Header, Course, Group, Total Need, Cost, and Priority.
Field type:
Header- text
Course -text
Group - text
Total Need - number
Cost - currency
Priority - text

I need them grouped like a tier, so first by Header then by Course then by Group and at each level I need to show the totals of Total Need and Cost, and just what priority

Thanks!

 

[PNGBill]

If your data is all in the same table then you don't need a query. Some use a query, of the table, just as a matter of choice.

On the left hand side of your form, you can right click and have the Group and sort properties.

Here you can define your groups, group headers and footers and Sort Order.

In the Headers and Footers you can use unbound text box controls to Calculate, Sum, Add, Conditional Sum etc plus bring in data with DLookup and other functions.
You can total for all groups including the Report Footer / header where of course you have Grand totals.

In the Detail part of the report you can have calculated controls for the records and also a running total.

 

[mgonzales]

Worked!
Thank you!!!!