Use Search Parameters To Find Content Contained Within A Field

[Bigbudgie]

Hello, I am new to the forum and hoping somebody could help me with a problem I am having (been driving me mad!)

I have created a table in access 2016, and have a text field that I have populated with Postcode abbreviations separated by" , " - I have created a search parameter and would like it to display a record if that part of the postcode is included in that field; e.g within the field is: AB, DE, FY, YO, and the search parameter is " YO"
I have tried various solution and tried to find the answer on the internet without success, Could someone please help, I am sure it is very simple but to a man of limited ability very frustrating,

many thanks
Bigbudgie

 

[Joe4]

Welcome to the Board!

You can use the InStr function, and if it returns any number greater than zero, then it has found the value.
See here for examples: MS Access: Instr Function

It is a bit curious as to why you would have multiple postal codes in a single field. It doesn't sound like a Normalized design (and that is usually something you want to strive for in Access).