Need to sort a report assending but it won't do it.

[Robert Johnson]

Hi all. First I'm not really conversant with Access. I'm doing this for a
client who needs one report modified and I got elected. So please be gentle.
Here is what I have. I have a query with 3 tables linked with 3 fields.
THe report generates fine except I need to sort the report by the date field
in the center table (purchase date) which I have set as sort by assending in
the query. However, it does not sort assending. Is it because it is the
center table in the hirearchy?

InvGroups, InvDetail, SpecialData all tied by ID fields. InvDetail has the
Purchase Date fileld that I need to sort on. It has the many against the one
in InvGroups.

Clear as Mud?

Thanks in advance.

Robert

 

[fredg]

Hi all. First I'm not really conversant with Access. I'm doing this for a
client who needs one report modified and I got elected. So please be gentle.
Here is what I have. I have a query with 3 tables linked with 3 fields.
THe report generates fine except I need to sort the report by the date field
in the center table (purchase date) which I have set as sort by assending in
the query. However, it does not sort assending. Is it because it is the
center table in the hirearchy?

InvGroups, InvDetail, SpecialData all tied by ID fields. InvDetail has the
Purchase Date fileld that I need to sort on. It has the many against the one
in InvGroups.

Clear as Mud?

Thanks in advance.

Robert

The sort order of the query is irrelevant to the report.
Sort the report in the Report's Sorting and Grouping dialog.
View + Sorting and Grouping

 

[Robert Johnson]

Thanks a million fredg. That was all I needed.. Everything is simple when
you know how to do it.. You can bask in the knowlege that you kept the feds
from shutting down a business in the morning. Thanks again.

Robert