Iam Using the SQL LIKE "*" & Forms!YourFormName.YourComboBoxName & "*" in the Criteria of a Access Query. i have 4 controls to be searched like this.
I need to search a field with Numbers. While Searching for "1" it returns 18,16,12,13 instead of just returning "1"
if i use =Forms!YourFormName.YourComboBoxName OR Forms!YourFormName.YourComboBoxName IS NULL
The Saved Query Gets Populated and when i open a report is shows ODBC Failed. Need help seriously here as project is based on searching thru number fields.
I need to search a field with Numbers. While Searching for "1" it returns 18,16,12,13 instead of just returning "1"
if i use =Forms!YourFormName.YourComboBoxName OR Forms!YourFormName.YourComboBoxName IS NULL
The Saved Query Gets Populated and when i open a report is shows ODBC Failed. Need help seriously here as project is based on searching thru number fields.