Use new field in query as criteria in different field

[JSoul]

HI,
I think this is a simple issue, but can't solve.
I have a query where I prompt for a Report_Date to create a new field; Report_Date:[ Enter date for report]
Is it possible to use the result from this prompt as a criteria in a different field?
for example, Order_Date based on the criteria of <=[Report_Date]

Thanks for help

 

[pbaldy]

No, but just use the same text in the prompt and you should only be prompted once.

 

[JSoul]

Thanks for response. The issue I am having is that I get two prompts ( parameter window) , each one asking for Report_Date.

 

[pbaldy]

What's the SQL of the query? I'm suggesting using this twice:

[ Enter date for report]

 

[Steve C]

Tentatively.

The Query Field criterion "Report_Date:[ Enter date for report]" will trigger an Enter Parameter Value box,

Might it be better to have a Calander control on a Form? Date entry is easy for the user and an invisible TextBox can hold the vba to calculate your second date based on the user entered date and pass it to the Query.

No doubt you chaps have already considered this idea.