Deirdre Marie
Access in Excess
- Local time
- Today, 16:30
- Joined
- Sep 17, 2001
- Messages
- 34
I will try to make this as simple as possible.
I have a report that runs off a query. The report has 2 grouping levels. For simplicity, the first grouping level is "Car or Truck". The second grouping level is "Chevy, Dodge, Ford etc."
I have it all set up to calculate the total of all Cars or Trucks and to also calculate the total of Chevy, Dodge, Ford within each Car or Truck heading.
Now, what I would like to do is calculate a total under "Car" thats sums "Dodge", "Ford", and *NOT* "Chevy".
Your assistance is much appreciated.
I have a report that runs off a query. The report has 2 grouping levels. For simplicity, the first grouping level is "Car or Truck". The second grouping level is "Chevy, Dodge, Ford etc."
I have it all set up to calculate the total of all Cars or Trucks and to also calculate the total of Chevy, Dodge, Ford within each Car or Truck heading.
Now, what I would like to do is calculate a total under "Car" thats sums "Dodge", "Ford", and *NOT* "Chevy".
Your assistance is much appreciated.
