can't sort database for report

  • Thread starter Thread starter kip
  • Start date Start date
K

kip

I have my database set up but can't get the information
sorted. i type in the query which sorts it fine, but when i
bring up the report it shows the entire database. help?!?!?
 
Kip,

I am not sure whether you mean that the report is not showing the data
you expect, or whether it is just the order in which it is shown.

If it's the first, and if you have a query that is returning the correct
set of records, then make sure that the report is actually based on the
query. Look at the Record Source property of the report, it should show
the name of the query.

If you are talking about the order, the report will only use the query's
sort order if the report has no Sorting & Grouping defined. Therefore,
the common wisdom is that the ordering of a report's data should always
be done in the report's Sorting & Grouping, rather than in the query.
 
Back
Top