Date Index with Multiple-Indices

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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!
 
Back
Top