PeterBaileyUk
asked on
query in access "like"
On my criteria line I have:
IIf([vehicle category code]<>'t',IIf((IsNull([cl ientcabder ived])=Tru e Or IsNull([cab TYPE])=True Or [clientcabderived]=""),-1, createtest class([cli entcabderi ved],[cab type],"cab")),0)
I need to say not like "t*" but not sure how
[vehicle category code]<>'t'
IIf([vehicle category code]<>'t',IIf((IsNull([cl
I need to say not like "t*" but not sure how
[vehicle category code]<>'t'
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.