Sorting and Grouping expression

  • Thread starter Thread starter Wm
  • Start date Start date
W

Wm

What is an "expression" for a Sorting and Grouping box where it has you
specify "Field/Expression"?

Thanks,
William
 
Wm said:
What is an "expression" for a Sorting and Grouping box where it has you
specify "Field/Expression"?
Click to expand...

It's there in case you want to sort/group on a partial value
or a combination of values from one or more fields. For
example, if you want to group on a persons name, you might
use something like:
=Lastname & "," & Firstname
or, if you want to group on the first 4 characters of a
product code field:
=Left(ProductCode, 4)

There's lots of way this feature can be used, but It isn't
really necessary. Instead, you could also add a calculated
field with the same formula in the report's record source
query and sort/group on that field.
 
Back
Top