Filter for Partical information within an alpahnumeric field.

  • Thread starter Thread starter Ghost
  • Start date Start date
G

Ghost

I have a text field within Access 2002 that only has alphanumeric numbers
such as:


lsp2002-00002
lsp2002-0004
lsp2004QC-0005

etc.

I want to filter for records that only have QC within them. For example, the
filter would return record lsp2004QC-0005 in above example.

Any assistance is greatly appreciated.
 
I have a text field within Access 2002 that only has alphanumeric numbers
such as:


lsp2002-00002
lsp2002-0004
lsp2004QC-0005

etc.

I want to filter for records that only have QC within them. For example, the
filter would return record lsp2004QC-0005 in above example.

Any assistance is greatly appreciated.
Click to expand...
look at instr()

like :
SELECT * FROM myTable WHERE instr(myTextfield,"QC")>0
 
Thanks all for reply. Found a real easy way to do it. Just when into the
field and highlighted the letter Q in one of the records. Next, right
clicked and selected filter by selection. Access automatically built the
correct filter context. Returned all records perfectlly.

Thanks once again for your professional assistance.
 
Back
Top