Add ALL to Combo - Unique Problem

[Dale Ring]

Access 2000

I am trying to add "ALL" to a combobox that is filtered by DLookup in
a table of defaults. I need the 3rd field to have the same value as
the filter.

This is what I have so far.

I'm getting a "missing operator" error in UNION Select "*", "ALL"
,"DLookUp("CountyFil","tblDefaults")" FROM QVehicleNumber; in the
DLookup part of the statement.

SELECT QVehicleNumber.VehicleNumberID,
QVehicleNumber.VehicleNumberDesc, QVehicleNumber.CountyFilter
FROM QVehicleNumber
WHERE (((QVehicleNumber.CountyFilter)=DLookUp("CountyFil ","tblDefaults")))
ORDER BY QVehicleNumber.VehicleNumberDesc UNION Select "*", "ALL"
,"DLookUp("CountyFil","tblDefaults")" FROM QVehicleNumber;

TIA
Dale

[DFS]

Dale,

The ORDER BY statement should be last.


"Dale Ring" <mt****@yadtel.net> wrote in message
news:d5**************************@posting.google.c om...

Access 2000

I am trying to add "ALL" to a combobox that is filtered by DLookup in
a table of defaults. I need the 3rd field to have the same value as
the filter.

This is what I have so far.

I'm getting a "missing operator" error in UNION Select "*", "ALL"
,"DLookUp("CountyFil","tblDefaults")" FROM QVehicleNumber; in the
DLookup part of the statement.

SELECT QVehicleNumber.VehicleNumberID,
QVehicleNumber.VehicleNumberDesc, QVehicleNumber.CountyFilter
FROM QVehicleNumber
WHERE (((QVehicleNumber.CountyFilter)=DLookUp("CountyFil ","tblDefaults")))
ORDER BY QVehicleNumber.VehicleNumberDesc UNION Select "*", "ALL"
,"DLookUp("CountyFil","tblDefaults")" FROM QVehicleNumber;

TIA
Dale

[Dale Ring]

Ok, I moved the order clause to the end and I still get the same
problem.
In the statement below I put ???? at the start & end of the part the
gives the error "missing operator"
SELECT QVehicleNumber.VehicleNumberID, QVehicleNumber.VehicleNumberDesc,
QVehicleNumber.CountyFilter FROM QVehicleNumber WHERE
(((QVehicleNumber.CountyFilter)=DLookUp("CountyFil ","tblDefaults")))
UNION Select "*", "ALL" ,????"DLookUp("CountyFil","tblDefaults")"????
FROM QVehicleNumber ORDER BY QVehicleNumber.VehicleNumberDesc;

Thanks
Dale

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[DFS]

"Dale Ring" <mt****@yadtel.net> wrote in message
news:3f*********************@news.frii.net...

Ok, I moved the order clause to the end and I still get the same
problem.
In the statement below I put ???? at the start & end of the part the
gives the error "missing operator"

Don't surround the Dlookup phrase in quotes or apostrophes.
SELECT QVehicleNumber.VehicleNumberID, QVehicleNumber.VehicleNumberDesc,
QVehicleNumber.CountyFilter FROM QVehicleNumber WHERE
(((QVehicleNumber.CountyFilter)=DLookUp("CountyFil ","tblDefaults")))
UNION Select "*", "ALL" ,????"DLookUp("CountyFil","tblDefaults")"????
FROM QVehicleNumber ORDER BY QVehicleNumber.VehicleNumberDesc;

Thanks
Dale

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!