sorting in ms access with static and dynamic data

[bemckinney]

i have a small file conversion program i am building in access. i need to
take the data that i have imported from a user specified file, and sort it
against a number of different criteria. the first sort i need to perform is
with a static list of data. there will be multiple records matching each of
the items on the static list. i think i am going to need to take the first
set of records that match the first item on the static list and move it to a
new table and then repeat that task for each set of records that match an
item on the static list. once i have the data separated in new tables i will
perform a series of different sorts specific to each of the new tables. some
of the tables will need to have sorts performed and some will not. ultimately
after i am completed with the sorting tasks i need to bring the tables
together in the order of the static list and export it to a .csv or .xls
file. needless to say i am pretty new to this so if i am over complicating
the process please let me know, advice is welcomed. thanks for your time and
help.

 

[bemckinney]

by the way i am using access 2003 with some vba code