Registered Member
|
I have a table with 82 records and no primary key. In the table data view, I can sort them alphabetically. But when I make a report based on that table, the records are out of order. I have also created a query with the same fields listed alphabetically. But when I make a report based on the query, the records remain out of order. What can I do? Thanks!
Edit (June 6, 2012): Finally I did it by creating a query, exporting the query to CSV and importing the CSV file as a new table. However, if I need to follow this procedure each time I update the table, it’s very tedious. Is there another easier way? |
Registered users: Bing [Bot], gfielding, Google [Bot], markhm, sethaaaa, Sogou [Bot], Yahoo [Bot]