>I have a SELECT statement that has a few unions. I dont use ORDER BY because I want to have selected records in the order I am selecting them in the Unions. But that's not happening. Any help, please?
>
>Thanks, Mark
If you want to have the records in the creation order, perhaps a field reflecting recno() from some of the tables might help.
recno() isn't very trustworthy with SELECTs from more than one table, so you may need to separate your SELECT statement into several pieces, and combine them in the end.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)