 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / August 2006Date Index with Multiple-Indices
I'm having trouble getting my table to show dates in correct order when it is the second index. I have a table with no primary key. There are duplicate names and dates, (unique entries are determined by both date and name) Eg. Joe 8/1 Joe 8/2 Sara 8/1 Sara 8/2 I have the name as my first index and date as the second index, but date is not showing in the correct order. If I remove name index altogether, dates order correctly, but not with name first. It is ordering the dates as follows: 09 10 01 02 03 04 05 06 07 08 11 So far I only have one month's worth of data. I have tried different date formats with the same result, currently it is formatted at mm/dd/yyyy. I have also checked regional and machine settings. When I manually sort by date, the dates order correctly, but then of course, the names aren't. Any help is appreciated. Where are you doing this? The order of data in a table is not important. In your queries and reports, you can define one or more fields to use as your sort. If you are trying to get the data sorted a certain way in the table, then you are wasting your time. The order in the table is irrelevant.  SignatureRick B > I'm having trouble getting my table to show dates in correct order when it > is [quoted text clipped - 31 lines] > Any > help is appreciated. Sorry. Trying to get it to sort in a form showing all entries in Datasheet view. > Where are you doing this? > [quoted text clipped - 39 lines] > > Any > > help is appreciated. I solved the problem. Thanks Rick. After your comment, I went back and looked at my form, and I hadn't put Date into my Order By statement on the form. Thanks for the help! > Where are you doing this? > [quoted text clipped - 39 lines] > > Any > > help is appreciated. |
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.