IIF in Form

[dazstarr]

Hi

I have a form called frmPupilSelection. I have a field in there called 'Year Group' which works out what School/Academic year the pupil is in based on their Date Of Birth.

Below is the IIF Statement:

=IIf(Month(Date())<9,Year(Date())-1,Year(Date()))-(IIf(Month([DateOfBirth])<9,Year([DateOfBirth])-1,Year([DateOfBirth])))-5

It works a treat in Access 2003 but i get ?Name in Access 2000??

Please can someone advise me on this problem. Is this an Access 2000 issues?

Many Thanks
Daz

 

[Rich]

Sounds like you have a missing/broken reference problem, now under the new forum rules I should write an essay on how to fix it, but it's been answered so many times here you can use the search button, if not post back for further assistance

 

[dazstarr]

Thanks!

Thanks Rich

I opened up a module - went to Tools - References and unticked a MISSING reference. All sorted now.

Many Thanks!

 

[Rich]

You're welcome