Cancanate fields then search by new field

[ItHurtsWhenIThink]

Here is my MS Access query:

SELECT
name_last,
name_first,
street + " " + Type AS NewStreet
FROM Voters
WHERE
NewStreet IN ('canyon LN','Crest DR')

When I run this, the "Enter Parameter Value" dialog box pops up. (for a value to use in "NewStreet")

Any suggestions?

My problem is that I am trying to get results that include voters from mobile home parks where there are individual named streets in the park. So I need to query by street name and street type (Ave, st, ln...). Problem is I have multiple streets and street types. So I thought just combine and then search by street and type.

Thanks

 

[dhookom]

Try:

SELECT 
     name_last, 
     name_first,
     street & " " & Type AS NewStreet
FROM Voters
WHERE
street & " " & Type IN ('canyon LN','Crest DR')

Duane
Hook'D on Access
MS Access MVP