In Access 2007 under MS 10 x64, I run my query sorting two of multiple fields in a table, which gives expected results. However, when I use that query as the record source for a report, the results are not the same. I don't understand why.
|
In Access 2007 under MS 10 x64, I run my query sorting two of multiple fields in a table, which gives expected results. However, when I use that query as the record source for a report, the results are not the same. I don't understand why.
I believe I should have asked this question in Computers & Technology>Programming>Databases>Access, but I don't know how to move it. I would appreciate guidance in that move.
A Report has its own sorting. You have to set the sorting in the Report design.
| All times are GMT -7. The time now is 02:05 PM. |