Avatar of SteveL13
Flag for United States of America

asked on 

How search for records based on certain criteria

I have a form where I can enter, for example, AB-3456 into a field.  Then when I click a command button I want all records to display that match the alpha-numeric portion .  It should return those records like AB3456-1, AB3456-2, AB3456-3, AB-3456-1, etc.

How can this be done?  In other words ignore the hyphens and just use the alpha-numeric.
Microsoft Access

Avatar of undefined
Last Comment
Dale Fye

8/22/2022 - Mon