Forum Discussion
Sorting my Access Database
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.
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
- Can 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.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