Report Grouping

[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.

 

[Allen Browne]

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.

 

[NNlogistics]

So Sweet
--
Thanks for any assistance

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.

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.