By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,720 Members | 2,135 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,720 IT Pros & Developers. It's quick & easy.

Records not filed chronoligically

P: 2
Hi. I have only limited knowledge of Access 2007, as the database I use was created by a former employee - I just use it & have no idea how it works! There are approx 600 customer records in the database, and each customer has anything from 5 to 150 or more order. My problem is that recently, new orders are suddenly being filed in the wrong order instead of most recent order first. So I have orders dated August 08 filed say in amongst orders from say November 07. Any ideas how I can correct this, and why it might have happened? It's not a massive problem - just a bit inconvenient!
Aug 12 '08 #1
Share this Question
Share on Google+
3 Replies


Expert 100+
P: 112
You'll have to explain what you mean by "filed" without seeing the structure of your database we can't really tell what this would mean. Does it have to do with the display of orders (i.e. you're used to seeing the newest dates first) or upon entry is it associating the wrong date with the current order, or perhaps something completely different than that?
Aug 12 '08 #2

P: 2
You'll have to explain what you mean by "filed" without seeing the structure of your database we can't really tell what this would mean. Does it have to do with the display of orders (i.e. you're used to seeing the newest dates first) or upon entry is it associating the wrong date with the current order, or perhaps something completely different than that?
Each customer has a form showing all their details. It also shows a list of their orders, with the newest at the top of the list. For example Order 50 out of a total of 50 is at the top of the list. However if I then open this order (by means of a button at the bottom of the customers page) the record is placed at say number 46 out of 50. If I then enter a new order (i.e. 51) this is then placed as 47 and so on.
Aug 13 '08 #3

NeoPa
Expert Mod 15k+
P: 31,489
Look at the record sorting of the form where the records are displayed.

Either it's not sorted by the date field, or it IS sorted by the date field but the field is displayed as a formatted string in the underlying query and THAT is what it's using to sort on.
Aug 13 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.