what criteria is available in access

[steallan]

Hi
I cant seam to find many examples of Criteria expressions you can put into queries. I now the basic stuff like "like" "not like" and doing anything with numbers is straight forward.

Is there a examples list anyone knows listing all of the types of exressions you can input?

At the moment i just want to select all the records that have the word "laser" in one field, but cannot get access to include records unless the entry is exactly "laser". I want to include any records that have laser as part of the entry.

What would the criteria be for that?

thanks for any help

 

[KenHigg]

like "*laser*"

???

 

[steallan]

oh hold on i've worked it out, it's really easy.

Not concentrating very well, i wish they'd hurry up and issue popbitch so i can stop working.

 

[KenHigg]

... i wish they'd hurry up and issue popbitch so i can stop working.

Issue a what?

 

[Mile-O]

Issue a what?

Weekly web update discussing the more gossip related side of celebrity i.e. female member of band may have made porno when young, guess who checks into hotels under this name, etc.