I'm trying to use wildcard with BETWEEN..AND statement.
I want to have an option to typ in the 1st and 2nd to retreive a range of date or nothing to get all the record or provide only the 1st date that will return all data with date equal to or greater than the 1st date.
Here is my statement, which doesn't work:
BETWEEN [1st date] & "*" AND [2nd Date] & "*"
What am I doing wrong?
PJ
I want to have an option to typ in the 1st and 2nd to retreive a range of date or nothing to get all the record or provide only the 1st date that will return all data with date equal to or greater than the 1st date.
Here is my statement, which doesn't work:
BETWEEN [1st date] & "*" AND [2nd Date] & "*"
What am I doing wrong?
PJ