How can I enable users to use wildcards in their searches on a form ?

[eternallyacontractor]

Hi,



I really appreciate any advice on this.

My experience is mostly in Oracle SQL, but in this position I am working with Access.

I have a Excel spreadsheet with an embedded query that pulls from an Access table. The users use a spreadsheet with an embedded query to search on a field called "Circuit ID", to bring up results showing the history of a given circuit id. Currently they have to enter an exact match, for example if the circuit id value is DHECHUIOY, they need to enter this exact value DHECHUIOY. They want instead to be able to enter DHEC and a wildcard character to bring back every value that begins with DHEC. There doesn't seem to be a way to do this in a spreadsheet with an embedded query.

I finally decided that it would be easier to create a form in Access

Does anyone know exactly how I can create a form which allows users to search on a value using wildcard characters ? (the user enters the wildcard character).

I'm on Access 2012, Windows Vista

Thanks again

Steve

[June7]

One way is with parameterized query where the wildcard is part of the filter criteria. User just enters the partial value, not the wildcard because the query has the wildcard. Review: http://datapigtechnologies.com/flash...earchform.html