Show Previous Year 1

[caykamanj1966]

I have a report and I created a text field on it and all I want to do is when the report is opened, that field will show the previous year.

How would I do this?

Your help will be greatly appreciated.

 

[dhookom]

You can set the control source to:
=Year()-1

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[caykamanj1966]

Thank you for responding.

I entered that, but then I get this error: The expression you entered has the wrong number of arguments

What now sir?

 

[combo]

Use reference date as argument, for instance =Year(Now())-1

combo

 

[caykamanj1966]

Thank you combo and that worked!

I am building my own Business Database, because I can't fine software that does everything that I want it to do

Have an awesome day!

 

[dhookom]

Thanks combo for correcting my mistake. I was tired when I answered

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016