Sorting Report by combo

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

I want to sort my report by combo's column 1 - how can i do that?

Sorting & Grouping doesnt seem to have such option, and placing
"FileGroup1.Column(1)" in Report-Data-OrderBy section doesnt give any results
either...

Please can anybody help? Thank you.
Lana
 
Create a query that uses both the main table for the report, and also the
table that feeds the combo.

You will then have the field from the combo's table in the report, so you
can use it in the Sorting 'n'Grouping box.

You may need to use an outer join in the query to get all records. More
info:
The Query Lost My Records! (Nulls)
at:
http://allenbrowne.com/casu-02.html
 
Back
Top