 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / May 2008Sorting Problem in Report
I'm having a problem that seems like it should be easy to fix... and yet I can't seem to fix it. I would like in a report to group by one of the fields in a table, and would like the grouping to be in ascending order. The report is grouping by the field, but it is all out of order. No matter what I do, it retains the same, wrong, non- ascending order. The table is in ascending order, and the field on the report is set to ascending order. Any idea why, with so much ascending order, it is still coming up out of order? Any help would be greatly appreciated! Where are you doing the sorting? How it's in the table or even a query doesn't matter. You must set the sort order in the report. Would it happen to be numerical characters stored in a text field? That can cause problems like so: 111 22 222 33 That's because text is sorted from left to right. Leading spaces can also cause problem. Maybe you could show examples of the problem.  SignatureJerry Whittle, Microsoft Access MVP Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. > I'm having a problem that seems like it should be easy to fix... and > yet I can't seem to fix it. I would like in a report to group by one [quoted text clipped - 5 lines] > order, it is still coming up out of order? Any help would be greatly > appreciated! On May 13, 4:54 pm, Jerry Whittle <JerryWhit...@discussions.microsoft.com> wrote: > Where are you doing the sorting? How it's in the table or even a query > doesn't matter. You must set the sort order in the report. [quoted text clipped - 27 lines] > > - Show quoted text - There are numbers involved-- it's a sorting of districts, which are assigned numerical values. So the order that comes up is: 10 11 12 13 ..etc 1 22 23 2 How do I get around this? Any help would be appreciated! Thanks! That is a proper sort for a text field that is storing number characters. Try changing the sort to = Val([DistrictField]) Val will convert the number string to a number. John Spencer Access MVP 2002-2005, 2007-2008 Center for Health Program Development and Management University of Maryland Baltimore County > On May 13, 4:54 pm, Jerry Whittle > <JerryWhit...@discussions.microsoft.com> wrote: [quoted text clipped - 45 lines] > > Thanks! > That is a proper sort for a text field that is storing number characters. > [quoted text clipped - 59 lines] > > - Show quoted text - Great! Thanks! Hi Open your report in design view Click on "View" in the menu bar Select "Sorting and grouping" In the dialoge box select the first line (dropdown arrowhead) Select the field to group by Then select assending You may need to open a group header and place you selected field in the header Have fun DeltaTech > I'm having a problem that seems like it should be easy to fix... and > yet I can't seem to fix it. I would like in a report to group by one [quoted text clipped - 5 lines] > order, it is still coming up out of order? Any help would be greatly > appreciated! > Hi > [quoted text clipped - 24 lines] > > - Show quoted text - Thanks for the reply--Yes, I'd already done this-- and it says ascending in that field when I reopen it-- but isn't ascending. This is what's confusing me! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.