FireViking
Programmer
I have created a query with multiple feilds and assigned wildcard criteria linked to my form to each feild. The following is an eg.
LIKE "*" & [forms]![formname]![formfeild] & "*"
this works fine when the query is run.
I have created a form with the intention of the user entering data into any 1 or more of the feilds to perform a search using the query and the results being shown in a listbox. The process works fine until I try to add a search between two dates using:
Between [Forms]![formname]![formfeild] And [Forms]![formname]![formfeild2]
This syntax works fine if no other criteria exist.
I thought this would work fine along with other feild criterias but it does not. The query returns nothing.
Is this the right syntax?
LIKE "*" & [forms]![formname]![formfeild] & "*"
this works fine when the query is run.
I have created a form with the intention of the user entering data into any 1 or more of the feilds to perform a search using the query and the results being shown in a listbox. The process works fine until I try to add a search between two dates using:
Between [Forms]![formname]![formfeild] And [Forms]![formname]![formfeild2]
This syntax works fine if no other criteria exist.
I thought this would work fine along with other feild criterias but it does not. The query returns nothing.
Is this the right syntax?