Controlling the order of query results

[AccessFanatic]

I am using a query to extract specific records (sales orders in this case) which are input via the use of a set of 12 brackets in the Sales Order Number field. Once I have finished inputting the 12 SOs which I wish to extract the query result always list them in either ascending or descending numerical order.



I wish them to appear in the order in which the SO numbers were input.

Any suggestions?

Thanks!

[andy49]

How are they stored in the table which might help? Date logged field? An autonumber field?


Sent from my iPhone using Tapatalk

[AccessFanatic]

They are actually coming from a dBaseIII file. The SO number field is an indexed text field.

[andy49]

So (sorry to appear repetitive), is there a field you could pull into the query as an ascending order.


Sent from my iPhone using Tapatalk

[AccessFanatic]

Why would I want to do that? I am trying to avoid a pre-set ascending or descending order. The numbers I input for the extraction are in a random order. That is the order in which I want the query result to be.

[aytee111]

input via the use of a set of 12 brackets

What does this mean - are the SO's entered in one long string or is it one SO per record? Please provide a sample of the data as it is entered and as you wish to see it.

[Bulzie]

Maybe add an EnteredDateTime field to table and default to Now() in table. Then pull that field into query and sort on that.

[jwhite]

Sounds like the OP has a field with a value like "[01] [23] [24] [52]" or such, but we can't assist further until the OP gives us example data as aytee111 requested.