I have tried making ID in query of the Report as Ascending and also I tried Order by as ID [ASCE] but neither is working and display all ID in ascending order. Few of ID are in ascending order in Report whereas others are not.
Competent Performer
Windows 7 64bit 
Access 2010 64bit
Query display ID in asceding order However Report doesn't
I have tried making ID in query of the Report as Ascending and also I tried Order by as ID [ASCE] but neither is working and display all ID in ascending order. Few of ID are in ascending order in Report whereas others are not.
VIP
Windows 7 32bit Access 2010 32bit
You have to use Group & Sort in the report design to order the data the way you want it.
John
Query doesn't display any results
Subform data doesn't populate Report or Query
Report data doesn't populate from Query, just opens query
Posting Permissions
Reply With Quote