Prompting For Date 2

M

Mooney88

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?".
 
R

Rick B

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?
 
M

Mooney88

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?".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top