IIF function in query

[ravness]

Hi guys,

I have a table which has several fields but im focusing on job names [sJobName].

Example:


sJobName
Jobone
Jobtwo
Jobthree
ZZ_Jobfour
ZZ_Jobfive

I want to somehow filter out any records which have a job name starting with ZZ_

How would I acheive this? I have tried using criteria in a query but dont know which function can do this properly.

Any help would be much appreciated

 

[Rabbie]

a criteria like this may help

Not Like "ZZ_*"

If used as the critera for the sJobName field this will allow all jobnames except those that start with "ZZ_"

 

[ravness]

thanks very much it works

 

[Rabbie]

Happy to have been of help