Passing a sort thru nested queries???

[painterz]

Hi All,

I have 3 queries based on address that creates a neighborhood directory report sorted by address. The first query sorts fine (AddressID and Address (this is a concantenated field of StreetNo & StreetName), the sort is on Address), and then passes the results to the next query and so on. There are no other sorts past the 1st query.

When I get to the 2nd query, the data is the result of the first query (AddressID and Address) plus a table (linked on AddressID plus people info), the data is no longer sorted by the results of the 1st query. It appears the data is sorted on AddressID of the 1st query, however when I delete that field it doesn't affect the sorting.

I need the sort of the Address field of the first query passed on through to all queries. If I sort on the Address field by the time I get to the 3rd query, the data will be in the wrong order, ie 102 B St, 102 C St, 102 D St, 103 B St, 103 C St, 103 D St. I know this is basic stuff but I can't see why the sort of the 1st query doesn't rule all of the results. Like I said earlier, there is no sorting going in the queries 2 - 3. Can someone please explain this to me???

Thanks

 

[JHB]

Then make the sorting in the last query instead!

 

[painterz]

You must have ESP! I was just working on that. The final query sorts correctly but now I'm having problems with the report. Thanks for your help! If I can't get the report sort correctly I'll post to the Report forum.

 

[JHB]

The sort order in a query does not affect how the data in the report is sorted, for sorting in a report you must use "Group and Sort" tools/band.
Here is a link how to do that:
http://office.microsoft.com/en-gb/t...cess-2007-database-RZ010292018.aspx?section=5