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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to create a report that will list unmatched records by Ticket Primary Key 0
Report Group Footer DLookUp 0
Weekly Report 2
200KB versus 35MB 0
Creating a Chart on form from selected data in query. 0
Can I save a sql statement generated by a search form? 1
Formatting Rule: Diplay Section based on Selection in another section 0
Report sorting 1

Top