NauticalGent
Ignore List Poster Boy
- Local time
- Today, 18:46
- Joined
- Apr 27, 2015
- Messages
- 6,750
Good afternoon everyone,
I have three select queries (from the same table) that I need to use as a RowSource for a combo box.
When run individually, the Order By works as designed. However, if appended to a temp table or in a Union query, the order gets garbled. I was able to make a Filter field with the Union, but the source query Order By gets over-rode.
In summary, I need to run the queries (step 1, step 2 and set 3) in sequence and have the original sort/order by maintained. Any ideas?
I have three select queries (from the same table) that I need to use as a RowSource for a combo box.
When run individually, the Order By works as designed. However, if appended to a temp table or in a Union query, the order gets garbled. I was able to make a Filter field with the Union, but the source query Order By gets over-rode.
In summary, I need to run the queries (step 1, step 2 and set 3) in sequence and have the original sort/order by maintained. Any ideas?
Attachments
Last edited: