Hi All,
I'm new to access and feeling my way in the dark a little.
I'm building a form for users to enter parameter criteria and it's coming along nicely. The form is such that a user can enter data for some or all parameters or any combination of them. All good.
Here comes the but...
In one field I need the user to be able to enter 'A11111111' and the search will return results for:
A11111111
A11111111#A
AAA@A11111111#A
The part I'm struggling with is the syntax for the wildcards at the start and end of the user entry especially the special characters. If it helps, the format will always be the same as the three examples, where 'A' is any letter, '1' is any number and the @ and # are as written.
The SQL for that part of the query is:
AND ((Table.PRODUCT = [Forms]![frm_SearchTransactions]![txtProduct]) OR ([Forms]![frm_SearchTransactions]![txtProduct] Is Null))
Any help or suggestions would be greatly appreciated.
I'm new to access and feeling my way in the dark a little.
I'm building a form for users to enter parameter criteria and it's coming along nicely. The form is such that a user can enter data for some or all parameters or any combination of them. All good.
Here comes the but...
In one field I need the user to be able to enter 'A11111111' and the search will return results for:
A11111111
A11111111#A
AAA@A11111111#A
The part I'm struggling with is the syntax for the wildcards at the start and end of the user entry especially the special characters. If it helps, the format will always be the same as the three examples, where 'A' is any letter, '1' is any number and the @ and # are as written.
The SQL for that part of the query is:
AND ((Table.PRODUCT = [Forms]![frm_SearchTransactions]![txtProduct]) OR ([Forms]![frm_SearchTransactions]![txtProduct] Is Null))
Any help or suggestions would be greatly appreciated.