Criteria within Reports

T

Tim

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

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
 
Top