Report Prompt from Query

[bertlady]

I have a query that looks like this:

>=[Forms]![YTD Criteria]![YrStrtDate]

I want the propmpt to say "Enter Start Date"

Instead, I get the cirteria.

What am I missing?

 

[PaulO]

You need someting like this as your query field criteria:-

>[Enter Start Date]-1

... where the date you type is what is used between the []

Then, the query will return data where the Date is greater than the date you typed in ... remember to type the date in the same/correct format as the dates in the source table/query/form.

 

[Brianwarnock]

This thread has been duplicated and should be ignored.

Brian