user entered data in a query

D

Darryl

Greetings,
I have a query with a "with clause" that has [enter beginning date]

I have a report that uses the query. I need to display the value entered
by the user in a that report.

so, the report has

Start Date:
End Date:

if I bind the text box to beginning date, I get prompted twice for the date
(once for the query and once for the report). Can I get to the date entered
in the query ?

hard to describe this. Any ideas ?

thanks,
Darryl
 
K

KARL DEWEY

Copy the [enter beginning date] into the FIELD row of the design view of the
query and put your output title and colon in front. Like this --
Start Date: [enter beginning date]

In another column do the same --
End Date: [enter end date]
 
Top