Using multiples of 'Like' problem

[ptaylor-west]

I am trying to use a multiple selection query.

First selection is a Post Code using the criteria

Like [Enter Post Code Like NE20 or blank for all] & "*"

Second selection is Business Type using the criteria:

Like [Enter Business Type or blank for all] & "*"

and finally Salesman using the citeria:

Like [Enter Salesmans Name or leave blank for all] & "*"

The idea is to use either/or in the criteria to allow a combination of user selected criteria but it produces incorrect results (ususally a blank screen). Any ideas?

 

[Mile-O]

Have a look at this thread - it might help.

 

[ptaylor-west]

Could you show me an example of what you suggest but selecting three seperate criteria so that I can see how this would work with multiple slections?

Your example form/table that I downloaded was very good.

 

[Mile-O]

I don't have time for making an example just now but you'd be wanting to build your criteria like:

WHERE (([Post Code]) " & IIf(IsNull([Post Code]), "Like '*" & Me.txtPostCode & "*'", "Like '*'")

 

[ptaylor-west]

Thanks, spot on!