Parameter values that can be used to another query

[budich]

Hi Friends,

I have old problem that I am still can not solve. I have several queries that have final output a report. At those queries I have input start_date and end_date several times because in some of my queries there are parameter values :
between [start_date] and [end_date].
I want only input the parameter value only once and it will put it in some variables and can be used to the next query.
Maybe this is a dumb questions, but really I am still confuse.
thank's in advance

 

[sera]

I did this once...I think. I used an unbound text box on a
form to input the query parameters and then I had the queries access the parameter using:
forms!formname!textboxname
in the criteria section of the query.
I only had one parameter...but there is syntax that allows you to specify that you want to query between two parameters.
It would be something like
Between [forms]![formname]![starting_date] And [forms]![formname]![end_date]
For a specific reference refer to the help files.
The title of the help file is
"Use a form to enter report criteria"
Hope this helps.
Sera

 

[budich]

Thank's Sera,

I know your idea, but we cannot use the values from input screen several times in some queries.If we have a macro with several query that ask the same data then we have to input it several times.
I have read in a post, we use global variable but I cannot still use this variable, does anyone can help me?
thank you