Report Grouping

  • Thread starter Thread starter NNlogistics
  • Start date Start date
N

NNlogistics

I have a Sales report that I would like to group by a text field
(fldAuthorizationCode). It has 3 general possibilities
1 - "Unapproved"
2 - "Check#" & " 99999"
3 - Approval code, which is some mix of alphanumeric Characters

I would like to group a report into those 3 catagories and I need a kick to
get started. Query or Report, either way. I would appreciate any advice.
 
Type an expression like this into the Field row in query design:
IIf([fldAuthorizationCode] Like "Check#*", 2,
IIf([fldAuthorizationCode] <> "Unapproved", 3, 1))

You could type type the expression (preceded with =) into the Sorting And
Grouping dialog in the report if you wish.

Presumably if the field is Null, it should be treated as unappoved, so the
expression is designed that way.
 
So Sweet
--
Thanks for any assistance


Allen Browne said:
Type an expression like this into the Field row in query design:
IIf([fldAuthorizationCode] Like "Check#*", 2,
IIf([fldAuthorizationCode] <> "Unapproved", 3, 1))

You could type type the expression (preceded with =) into the Sorting And
Grouping dialog in the report if you wish.

Presumably if the field is Null, it should be treated as unappoved, so the
expression is designed that way.

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

NNlogistics said:
I have a Sales report that I would like to group by a text field
(fldAuthorizationCode). It has 3 general possibilities
1 - "Unapproved"
2 - "Check#" & " 99999"
3 - Approval code, which is some mix of alphanumeric Characters

I would like to group a report into those 3 catagories and I need a kick
to
get started. Query or Report, either way. I would appreciate any advice.
Click to expand...
Click to expand...
 
Back
Top