I have a report, 11 parents with names & addresses & each has a pickup order assigned to it but the report won't put #10 & 11 in order. It goes 1, 10, 11, 2,3 etc. Any help?
Grouping in a report
Novice
Windows 7 32bit 
Access 2007
I have a report, 11 parents with names & addresses & each has a pickup order assigned to it but the report won't put #10 & 11 in order. It goes 1, 10, 11, 2,3 etc. Any help?
Who is John Galt?
Windows XP Access 2007
Your numbers are being seen as text rather than numbers. It could be the data type of the field or some function being applied along the way.
Novice
Windows 7 32bit Access 2007
Thanks. it worked by changing from text to number in the table.
Who is John Galt?
Windows XP Access 2007
No problem. Text = alphabetic sorting.
Grouping on Report
Posting Permissions
Reply With Quote