bruceblack
Registered User.
- Local time
- Today, 12:33
- Joined
- Jun 30, 2017
- Messages
- 119
Hi everyone. Stuck here with some query critera.
Some help would be much appreciated
I have query that filters between 2 given dates.
However when input no dates (if just want all the date) it returns blank.
So i tried to fix this using Nz, which doesnt seem to work at all.
I tried "Or like...year" which does work, if i leave it empty it gives me everything. But the "Between" code doesnt work anymore.
Here's my criteria in my query:
Between Nz([Forms]![avs_filter_form]![startdate]) And Nz([Forms]![avs_filter_form]![enddate]) Or Like "*" & [Forms]![avs_filter_form]![yearselect] & "*"
No clue why this doesn't work. Please help. Tried so many things.
Some help would be much appreciated
I have query that filters between 2 given dates.
However when input no dates (if just want all the date) it returns blank.
So i tried to fix this using Nz, which doesnt seem to work at all.
I tried "Or like...year" which does work, if i leave it empty it gives me everything. But the "Between" code doesnt work anymore.
Here's my criteria in my query:
Between Nz([Forms]![avs_filter_form]![startdate]) And Nz([Forms]![avs_filter_form]![enddate]) Or Like "*" & [Forms]![avs_filter_form]![yearselect] & "*"
No clue why this doesn't work. Please help. Tried so many things.