Group on formula - Newbie question 1

[pgmr]

Hi,
I inherited Access this week.
I have a report with subtotals after each group. How can I combine 3 groups into one.
My query has: Item field, Afield, BField, CField, DField.
Item is in AGroup if Afield=yes, Item is in BGroup if Bfield=yes.
On my report I have Grouping levels A,B, C,D...
I want to combine A and B and subtotal and have C and D remain as individual groups with subtotals after each.
Thank you in advance for your help.

 

[PaulBricker]

You can try this. In the query set up a new column with this expression.

IIf(AField = Yes Or BField = Yes,1,IIf(CField = Yes,2,3))

Then you should be able to group on this value to keep A and B together and C and D separate.

Paul

 

[pgmr]

Yes, that is what I was looking for! Thank you
But why, would my report prompt me for a parameter value
for my expression.

Thanks, again

 

[PaulBricker]

pgmr, I'm not sure why you would get parameters. Can you post what it is you are seeing (and exactly what the parameter says).

Paul

 

[pgmr]

Hi Paul,
Nevermind on the parameters, my error.
Again, thank you fo r your help

pgmr