Sorting in a report

S

stephanie

I have a report that I want to sort based on a field in a
table. I tried to run a query with that table included,
but for some reason it increases the records by about
200. Is the a way to worth the report based on this
field. Maybe have a field, not visible in the report that
comes from another table?

Steph
 
F

Fredg

Stephanie,
I suspect you have those extra 200 records because you haven't set the
relationships between the tables in the query, or there is some criteria
that you haven't set.

Be that as it may, the only reliable way to sort a report is through the
Report's Sorting and Grouping dialog:
View + Sorting and Grouping
 
Top