How could I query msaccess table into this sequence: ?

[klauriens]

How could I query msaccess table into this sequence: ?

I have data in this order |             I want data in this order
           A                               |               A
           A                               |                                                          B
           A                               |                                                          C
           A                               |                                                          A
           B                               |               B           
B                                                                          |               C
           B                               |               A
           C                                                                          |               B
           C                               |               A

I want to retain all the data so duplicate wizard cant help me. The purpose of this is to see the records of A,B,C first instead of seeing all records of As, Bs and Cs. Help me pls. A bit urgent. Thanks, LA

[jzwp11]

You would need some other field in your table that holds a value that is the same for each group of A, B, C. For example

Customer1|A
Customer1|B
Customer1|C
Customer2|A
Customer2|B
Customer2|C

[klauriens]

@jzwp11
Thanks for the fast reply. Actually, there is no other field in my table that will differentiate the records as what you have shown. Is there no other way to achieve this just by only looking on the target column? I want to see the records of that column in their first instance, then second, then third...consecutively.

I will still keep your post in mind if I could make a workaround.
Thanks, pls reply again.
LA

[jzwp11]

I want to see the records of that column in their first instance, then second, then third...consecutively

Do you have a date field that is associated with first instance second instance etc.?

[klauriens]

No. The date in the table is all the same. But you give me an idea in your first reply. How could I make this possible:

My_Data|Check_Instance
A                          |1
A                          |2
A                          |3
A                          |4 
B                          |1
B                          |2
B                          |3
C |1
C                          |2

How could I make a column that will check the instance of the other column. By this, I could simply sort the "Check_Instance" column by ascending and the "My_Data" will be arrange accordingly as I planned to.

I think I will post another for this.

Thanks,
LA

[jzwp11]

You should be able to just modify the order in the query; if you look at the query in SQL view it would look something like this

SELECT my_data, check_instance
FROM yourtablename
ORDER BY check_instance ASC