J
Jribs
I am using 2 combo boxes that allow input on a form. I am trying to set up a
query that that allows me to select a name and then a [between] date. The
query runs the between dates but will not work for the name. I am using -
Like "*" & [Associate Name] & "*" - but it does not prompt when the query is
run only the Between date runs.
Table (Tblevents) colums are:
Associate Name
Date
Function
Sub Function
Oldest
Hold Over
query that that allows me to select a name and then a [between] date. The
query runs the between dates but will not work for the name. I am using -
Like "*" & [Associate Name] & "*" - but it does not prompt when the query is
run only the Between date runs.
Table (Tblevents) colums are:
Associate Name
Date
Function
Sub Function
Oldest
Hold Over