H
hanski
Hi.
I have a query which asks user to give StartingDate and ClosingDate.
It´s like this: Between [Give StartingDate:] And [Give ClosingDate].
It´s working.
BUT if user want´s to see all events (that is: He/She do not want to
restrict events by date) it won´t work.
I tried to use this: Like "*" & (Between [Give StartingDate:] And
[Give ClosingDate:]) & "*", but it does not give me the right answer.
How can user either give date range or if he/she push enter-button,
query will give him/her all events?
Hope you understand what I mean...
Hannu
I have a query which asks user to give StartingDate and ClosingDate.
It´s like this: Between [Give StartingDate:] And [Give ClosingDate].
It´s working.
BUT if user want´s to see all events (that is: He/She do not want to
restrict events by date) it won´t work.
I tried to use this: Like "*" & (Between [Give StartingDate:] And
[Give ClosingDate:]) & "*", but it does not give me the right answer.
How can user either give date range or if he/she push enter-button,
query will give him/her all events?
Hope you understand what I mean...
Hannu