Quick Wildcard question

[phillsheen]

In my query Im using the criteria

="cashpayer*"

to bring up any records in this field which start with cashpayer but its not working. Is my text correct?

Cheers
Phill

 

[PeterF]

"=" means the same, to use wildcards you need "like", so in your case it should be:

like "cashpayer*"

 

[burrcm]

or like "cashpayer" & * Result is probably the same, but I am not sure without testing if the * works inside inverted commas.

Chris B

 

[phillsheen]

Works great!
Cheers
Phill