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

  • Thread starter Thread starter Robert Johnson
  • Start date Start date
R

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
 
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
Click to expand...

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
 
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
 
Back
Top