Condition by date entered by the user

[Aniko]

Hi,
Could someone please help me?
I have a make table query based on three different tables. In one of these
tables there is the purchase date field. I would like the query to ask the
user, which date range of the records should be used to make the new table.

I added the Condition to the query field such as “Like[Please enter the
date]&â€*.*â€, to ask the user to enter the date but the query does not produce
any results. And this does not allow entering the range of dates either.

How can I solve this problem?
Regards,
Aniko

 

[Allen Browne]

See:
Limiting a Report to a Date Range
at:
http://members.iinet.net.au/~allenbrowne/casu-08.html

 

[Aniko]

Thanks Allen,
It works, but why does it ask for start date twice?
Aniko

See:
Limiting a Report to a Date Range
at:
http://members.iinet.net.au/~allenbrowne/casu-08.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Could someone please help me?
I have a make table query based on three different tables. In one of these
tables there is the purchase date field. I would like the query to ask the
user, which date range of the records should be used to make the new
table.

I added the Condition to the query field such as "Like[Please enter the
date]&"*.*", to ask the user to enter the date but the query does not
produce
any results. And this does not allow entering the range of dates either.

 

[Allen Browne]

Presumably you used the Method 1 in the article.
Did you declare the parameter?

It should ask once only if the spelling is exactly the same.
Perhaps you used the expression twice, once with a space?
Or perhaps your query is based on another query which also has its
parameter?

Or perhaps this query is being called by a subreport or other object that is
running multiple times?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Thanks Allen,
It works, but why does it ask for start date twice?
Aniko

See:
Limiting a Report to a Date Range
at:
http://members.iinet.net.au/~allenbrowne/casu-08.html

--

Could someone please help me?
I have a make table query based on three different tables. In one of
these
tables there is the purchase date field. I would like the query to ask
the
user, which date range of the records should be used to make the new
table.

I added the Condition to the query field such as "Like[Please enter the
date]&"*.*", to ask the user to enter the date but the query does not
produce
any results. And this does not allow entering the range of dates
either.

 

[Aniko]

Thanks Allen, this was a copy and paste error of my behalf.
Now it works well.
Regards,
Aniko

Presumably you used the Method 1 in the article.
Did you declare the parameter?

It should ask once only if the spelling is exactly the same.
Perhaps you used the expression twice, once with a space?
Or perhaps your query is based on another query which also has its
parameter?

Or perhaps this query is being called by a subreport or other object that is
running multiple times?

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

Thanks Allen,
It works, but why does it ask for start date twice?
Aniko

See:
Limiting a Report to a Date Range
at:
http://members.iinet.net.au/~allenbrowne/casu-08.html

--

Could someone please help me?
I have a make table query based on three different tables. In one of
these
tables there is the purchase date field. I would like the query to ask
the
user, which date range of the records should be used to make the new
table.

I added the Condition to the query field such as "Like[Please enter the
date]&"*.*", to ask the user to enter the date but the query does not
produce
any results. And this does not allow entering the range of dates
either.