Sort Order of Queries

I have a query where I enter the auto numbers allocated by access in a table
to produce a report of interview questions. I want the query to be in the
order I enter so when I mail merge it they come out in the order we are going
to ask them. The query is in the form of "1 or 7 or 3 or 212" etc. I have
the sort order on no sort but when the query is processed it is not displayed
in the order I have entered. Any ideas??

Add a Date/Time field to your table.
Set its Default Value property to: =Now()
In your report's Sorting And Grouping dialog, sort by this field.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Samaritans" wrote in message
...
I have a query where I enter the auto numbers allocated by access in a
table
to produce a report of interview questions. I want the query to be in the
order I enter so when I mail merge it they come out in the order we are
going
to ask them. The query is in the form of "1 or 7 or 3 or 212" etc. I have
the sort order on no sort but when the query is processed it is not
displayed
in the order I have entered. Any ideas??