MS query rewrote SQL

hon

Board Regular
Joined
Oct 10, 2005
Messages
73
I am importing data from an external data source. The query I used contained parameters and MS query somehow rearranged the where clause which produced different results. I suspect it has some thing to do with the parameters. Any ideas how to stop MS query from rearranging my query?
 

Some videos you may like

Excel Facts

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Watch MrExcel Video

Forum statistics

Threads
1,119,002
Messages
5,575,499
Members
412,670
Latest member
Khin Zaw Htwe
Top