Forum Discussion
JLovell
Sep 01, 2020Copper Contributor
Sorting my Access Database
I am having trouble sorting my database. ONE entry will not sort properly. I have erased the entry and re-entered it without success. I am sorting on three fields out of maybe thirty and everything s...
Sep 04, 2020
Sounds to me the issue is because there no lot prefix, so this impacts sorting.
It would also help if you gave use a sample of your data, the current sorting result and the desired sorting result. You also need to provide us with the SQL Statement you are using.
If you can share a copy of your db (please remove any confidential information first) by uploading it to an online folder (OneDrive, GoogleDrive, DropBox, ...) and then share the link we could take a closer look at the data and SQL statement you need to use to get thing sorted the way you want it to be.
JLovell
Sep 04, 2020Copper Contributor
These two screen shots show the top INCORRECT record out of sequence and all the other records in correct sequence and the bottom screen shot shows the sort I am using. Thanks for any help - Jeff
- Sep 04, 2020Can you show me a screenshot of your table design structure with the data types.
Normally, one is not supposed to work in tables, so this isn't normally a consideration. You should be working through forms built upon queries.- JLovellSep 05, 2020Copper Contributor
I believe this is a query off the form
and 958 still show at top
I think this is an SQL of the query
these should be table design
Thanks as always for any help - Jeff