Store "Between and data" from a query

I

Ixak

Hello
I have a query in which I introduce two dates, beginning and end. This query
makes some calculations and is used for a report.
Is it possible to store thise information I introduce for the date so I can
put in the report?

I mean, if the report asks me for the beginning date and ending date, I´d
like this information to appear in the report.
Thanks for all
 
A

Al Campagna

Ixak,
Most commonly, the query behind the report would have parameters something like...
[Please Enter Starting Date] and [Please Enter Ending Date].
Once the user enteres the 2 dates, those parameters can be displayed on the report.
Place an unbound text control on the report with a ControlSource of...
= [Please Enter Starting Date]
would display what the user entered in response to the [Please Enter Starting Date]
parameter prompt. Same for [Please Enter Ending Date].
 
I

Ixak

Thanks for your help.
I got it but I am trying to do the same thing in a form and I don´t success.
Do you if the way of doing it is the same?


Al Campagna said:
Ixak,
Most commonly, the query behind the report would have parameters
something like... [Please Enter Starting Date] and [Please Enter Ending
Date].
Once the user enteres the 2 dates, those parameters can be displayed on
the report.
Place an unbound text control on the report with a ControlSource of...
= [Please Enter Starting Date]
would display what the user entered in response to the [Please Enter
Starting Date] parameter prompt. Same for [Please Enter Ending Date].

--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

Ixak said:
Hello
I have a query in which I introduce two dates, beginning and end. This
query makes some calculations and is used for a report.
Is it possible to store thise information I introduce for the date so I
can put in the report?

I mean, if the report asks me for the beginning date and ending date, I´d
like this information to appear in the report.
Thanks for all
Click to expand...
Click to expand...
 
A

Al Campagna

Ixak,
Just like a report, the form has a query behind it. The procedure would be exactly the
same.
Place your parameters in the query behind the form, and when opened, the user will be
prompted for Start/End dates, and only those records will be returned.

--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

Ixak said:
Thanks for your help.
I got it but I am trying to do the same thing in a form and I don´t success.
Do you if the way of doing it is the same?


Al Campagna said:
Ixak,
Most commonly, the query behind the report would have parameters something like...
[Please Enter Starting Date] and [Please Enter Ending Date].
Once the user enteres the 2 dates, those parameters can be displayed on the report.
Place an unbound text control on the report with a ControlSource of...
= [Please Enter Starting Date]
would display what the user entered in response to the [Please Enter Starting Date]
parameter prompt. Same for [Please Enter Ending Date].

--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

Ixak said:
Hello
I have a query in which I introduce two dates, beginning and end. This query makes
some calculations and is used for a report.
Is it possible to store thise information I introduce for the date so I can put in the
report?

I mean, if the report asks me for the beginning date and ending date, I´d like this
information to appear in the report.
Thanks for all
Click to expand...
Click to expand...
Click to expand...
 
Top