Sorting in a report by a lookup value

B

Benjamin

I'm looking to sort my report according to the values in a lookup column.
But, there isn't an option in the report wizard to sort the report by column,
only by column.value

But then when i run the report with column.value, that field is empty. Any
suggestions?

Thanks!
 
A

Allen Browne

Create a query that uses both your main table and also the lookup table.

Output the text column from the lookup column, as well as the other columns
you want.

Base the report on the query.

You now have the lookup text column in the report, and so you can sort on
it.
 
Top