Forum Discussion
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...
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.
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
- I've tried replicating the issue, but have been unable to. Any chance you could upload a copy of your database to OneDrive, GoogleDrive, Dropbox, ... And provide us with a link for closer inspection?
Be sure to delete any confidential information beforehand.