S
Steve Stad
I have a UNION Qry (example below). After I run the qry and sort on a field
(eg invoice date) in the datasheet view - the next time I run the qry it asks
for the parameter a second time. Can you tell me the difference between
'Order by' and 'Sort' and where to put a sort or order statement in this qry
so the qry will still run optimally (i.e., without a second paremeter window
popping up).
SELECT [SEP07].*
FROM [SEP07]
Where ((([SEP07].[Circuit ID]) Like "*" & [ENTER VALUE]))
UNION SELECT [Oct07].*
FROM [Oct07]
Where ((([Oct07].[Circuit ID]) Like "*" & [ENTER VALUE]))
UNION SELECT [Nov07].*
FROM [Nov07]
Where ((([Nov07].[Circuit ID]) Like "*" & [ENTER VALUE]));
(eg invoice date) in the datasheet view - the next time I run the qry it asks
for the parameter a second time. Can you tell me the difference between
'Order by' and 'Sort' and where to put a sort or order statement in this qry
so the qry will still run optimally (i.e., without a second paremeter window
popping up).
SELECT [SEP07].*
FROM [SEP07]
Where ((([SEP07].[Circuit ID]) Like "*" & [ENTER VALUE]))
UNION SELECT [Oct07].*
FROM [Oct07]
Where ((([Oct07].[Circuit ID]) Like "*" & [ENTER VALUE]))
UNION SELECT [Nov07].*
FROM [Nov07]
Where ((([Nov07].[Circuit ID]) Like "*" & [ENTER VALUE]));