Prompting For Date 2

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report with a date parameter in the query. I created a text box and
entered the following in the control source: =[Enter Date]. I want to be
able to have the date show on the report but all I get is "NAME?".
 
Is that EXACTLY how it is in the query? Whatever you have in the query
criteria needs to be EXACTLY placed in the report unbound text box. Did you
include the space between the words in both the query and the report?
 
The criteria is exactly the same in the query and the unbound text box.

Rick B said:
Is that EXACTLY how it is in the query? Whatever you have in the query
criteria needs to be EXACTLY placed in the report unbound text box. Did you
include the space between the words in both the query and the report?

--
Rick B



Mooney88 said:
I have a report with a date parameter in the query. I created a text box
and
entered the following in the control source: =[Enter Date]. I want to be
able to have the date show on the report but all I get is "NAME?".
 
Back
Top