Report displaying wrong order

[mapat]

Hi everyone,

I have a report and its record source is a query that supposedly orders the records by 2 fields (filedA and then by fieldB). When I open the datasheet view for that query, it shows me the correct and expected order, but the report shows the records in a different order. Can anyone help me with this?

This is really urgent, I would have to finish this in the next hour or so, so I would really appreciate a response as soon as possible.

Thank you very much everyone.

 

[HiTechCoach]

Thew sorting should be done in the report using the grouping/sorting. Note: This overrides any soring in the query.

 

[mapat]

Thew sorting should be done in the report using the grouping/sorting. Note: This overrides any soring in the query.

I assume you are talking about the "Order By" property of the report, right? If so, I tried that too and it still doesn't work.

Thanks.

 

[HiTechCoach]

No, you assumed incorrectly. I am Not referring to the the "order by", but the sorting/grouping.


Since you did not specify what version of Access you are using, I can not give you specifics, only to search the help.

 

[HiTechCoach]

See:

How to sort records in an Access database in Access 2002

 

[mapat]

No, you assumed incorrectly. I am Not referring to the the "order by", but the sorting/grouping.


Since you did not specify what version of Access you are using, I can not give you specifics, only to search the help.

I am using ACCESS 2007
Thanks again

 

[mapat]

sorry, the PC I have to work on has ACCESS 2003, so this is what I am currently using

 

[mapat]

I am using ACCESS 2003

 

[HiTechCoach]

The link I supplied for 2002 will also apply to 2003.