I have a table with records in a desired sort order (I appended them
to the table in the order I wanted). It would look something like
this:
Table 1
Name Date Code DisplayOrder
------ ------------ ----------- ------------------
A1 1-21-04 XB56 10
A1 1-21-04 XB56 20
A1 1-21-04 XB56 30
A2 1-21-04 CT57 40
C2 1-21-04 DF58 50
C1 1-21-04 NN59 60
B1 1-21-04 GJ60 70
B2 1-21-04 FT61 80
B2 1-21-04 FT61 90
I now run a SELECT DISTINCT query on this table - not including the
DisplayOrder field and I get:
Table 2
Name Date Code
------- ------------ -------------
A1 1-21-04 XB56
A2 1-21-04 CT57
B1 1-21-04 GJ60
B2 1-21-04 FT61
C1 1-21-04 NN59
C2 1-21-04 DF58
Here is my problem: I have to drop the DisplayOrder Column to get the
SELECT DISTINCT to run, but then it reorders the recordset. In this
case, it is now ordered by Name (alphabetically ). Table 2 has the
data I want, just not in the order I want. Can anyone help?
Thanks in advance.
tom r