Concanenate + Condition

[If]

Good evening,

I have this procedure which enables me to populate a combo box.

SELECT Name & ' ' & City AS NameCity
FROM TableCustomers
ORDER BY Name & ' ' & City;

In my table "TableCustomers", I have a field "Notices"
I would wish that my combo box is populated only by people who have the word
"Expert" in the field "Notices"


I tested this procedure, but that does not work.


SELECT Name & ' ' & City AS NameCity
FROM TableCustomers
WHERE Notices = Expert
ORDER BY Name & ' ' & City;


Would somebody have an idea?

 

[Rob Oldfield]

Paste your condition into the SQL window of a query and you'll find that it
won't work. Try this instead...

SELECT Name & ' ' & City AS NameCity
FROM TableCustomers
WHERE Notices = "Expert"
ORDER BY Name & ' ' & City;

 

[If]

Very Thanks

Paste your condition into the SQL window of a query and you'll find that
it
won't work. Try this instead...

SELECT Name & ' ' & City AS NameCity
FROM TableCustomers
WHERE Notices = "Expert"
ORDER BY Name & ' ' & City;