Parameters in a report

[Penny]

I don't thing I'm doing this correct. When I do this the
parameter says Forms!frmReportCriteria!txtWotYear then I
type in a year and it's blank query. Field Name is Year
and just the year is the data.

-----Original Message-----
Create a small unbound form named

(say) "frmReportCriteria", with a text box

that has these properties:
Name txtWotYear
Format General Number
Default Value =Year(Date())
Validation Rule Between 2000 And 2200
Validation Text Enter a 4-digit year

In the Criteria row of your query, under the date field, enter:
Between DateSerial([Forms]![frmReportCriteria]! [txtWotYear], 1,1) And
DateSerial([Forms]![frmReportCriteria]![txtWotYear], 12, 31)

Do the same in the query for the subreport.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have a report with a subreport. In each on the queries
I'm asking for the same information [Enter the Year]. When
the report is retrieved it asks for the year three times.
Is there anyway just to ask for the year once?

Thanks in advance

Penny

.

..