Sort Order of Queries

S

Samaritans

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??
 
A

Allen Browne

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.
 
Top