Criteria within Reports

[Guest]

Access 2000.

I have a report that when opened requires you to put in an expiration date.
I.E. 12/31/2005
How do I set up a text box so that will show only the year?

 

[Luiz Cláudio C. V. Rocha [MVP]]

Hi Tim,

suppose the report's criteria says "[Type the date:]".

You have to place a textbox on your report and set its control source to:
=Year([Type the date:])

Luiz Cláudio C. V. Rocha
São Paulo - Brazil