Wildcard Use in Queries (*)?

S

shcram

I need to use a wildcard type search to mark records that have
particular letter in a larger field: IIf([studentcode]="*V*",1,0). I
this example, the format of the studentcode is NNL-NNNN where N is
single digit number and L is an alpha letter. I want to select al
studentcodes that have a "V" in the third position.

I posted this several days ago but have had no replies.

Finally, can you recommend a good manual on Access queries and reports
I've got the "Getting Started" and "Access for Dummies" but they ar
much too basic for this type of question --

Thanks,
Su
 
A

Allen Browne

Try the Like operator:
IIf([StudentCode] Like "##V*", 1, 0)

Replace the # with ? if you want to return records with alpha-characters
(not just digits) in the first 2 places.
 
S

shcram

Thanks -- so simple a solution! Can you recommend a good "Access
manual for this type of question?
Su
 
A

Allen Browne

There's heaps of material out there. Anything by Alison Balter or John
Viescas is good value, or Ken Getz for more advanced stuff.
 
Top