Wm said:
What is an "expression" for a Sorting and Grouping box where it has you
specify "Field/Expression"?
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.
