Attach a label to a database

[Steve_H via AccessMonster.com]

Attach a label to a database
I am trying to attach my labels, in an access report, to a data table that
has the field defined.

Ex: CY = 2009

PY = 2008

So when a new year comes, from 2009 to 2010, the CY will change to 2010 in
all 50 reports.

Is this possible?

Thanks

Steve

 

[fredg]

Attach a label to a database
I am trying to attach my labels, in an access report, to a data table that
has the field defined.

Ex: CY = 2009

PY = 2008

So when a new year comes, from 2009 to 2010, the CY will change to 2010 in
all 50 reports.

Is this possible?

Thanks

Steve

No need to track the year.
Delete that CY field (and the PY field as well).

Just use an Unbound text control in each report as a label.
For the current year, set it's control source to:
=Year(Date())

Each report will display the current year.

To display the previous year, use:
=Year(Date())-1

 

[Duane Hookom]

Can we assume you want to display the current year in a text box on a report?
If so, use a text box with a control source of:
=Year(Date())
If you want something else, you will need to provide more specific
information. Try to understand the difference between a database, report,
label, caption, text box,...