Wildcard Use in Queries (*)?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

shcram - 11 Nov 2005 06:40 GMT

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

--
shcramPosted from - http://www.officehelp.i

Reply to this Message

Allen Browne - 11 Nov 2005 07:34 GMT

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.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> I need to use a wildcard type search to mark records that have a
> particular letter in a larger field: IIf([studentcode]="*V*",1,0). In
[quoted text clipped - 7 lines]
> I've got the "Getting Started" and "Access for Dummies" but they are
> much too basic for this type of question --

Reply to this Message

shcram - 11 Nov 2005 15:51 GMT

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

--
shcramPosted from - http://www.officehelp.i

Reply to this Message

Allen Browne - 11 Nov 2005 16:23 GMT

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

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

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

Reply to this Message