SORTING/GROUPING

[Barry Shadduck]

Anyone familiar with syntax for an Expression in the
Report Sorting and Grouping Field/Expression window?

Trying to use a one character field to create 3 groups
depending on value stored in the field.

Example:
Field is called RECORD-TYPE
Field can have 1 of 3 values (C, L, or M)

So would like to form an expression to relate this, but
can't seem to come up with any workable syntax.

My instinct is to try REPORT-TYPE = "C", as an expression,
but of course it does not work. Maybe I'm trying to do
the impossible?

Thanks

 

[Duane Hookom]

An expression can either be a field name or an expression that begins with
"=". All you should need in this field/expression is:
[Record-Type]
If you want records sorted with L first followed by M then C, use:
=Instr("CML",[Record-Type]) Descending