Sorting in a report by a lookup value

  • Thread starter Thread starter Benjamin
  • Start date Start date
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!
 
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.
 
Back
Top