GingerScouser
New member
- Local time
- Today, 06:10
- Joined
- Feb 2, 2004
- Messages
- 8
Hi,
I'm currently experiencing some problems with my Access 2000 Database. I'm designing a database for a Youth Football Team you see, but have become a little stuck on something.
In a table I have, I've created a field called DOB. What I want to do, is be able to enter a certain age, but have it be between specific ones.
E.g. If the player is in the U-13's team, and I enter his DOB as 14/12/1987, then an error message will pop up, as that would mean the person would be too old, just the same as it will if I enter something such as 01/04/2000, meaning the player would be too young.
I've tried numerous things to accomplish this, but am constantly failing. I have five tables which I want to use this in, and the one I'm currently testing it in is the Under 12's Team table.
I have tried using this validation rule:
=Now()-[DOB]<12 And Now()-[DOB]>11
Meaning that the player can be no less than the age of 11 but no more than the age of 12. However, it doesn't work whatsoever, because when I enter an erroneous piece of data, it allows it, even though all of my validation is correct.
I'd much appreciate any help that can be provided on this. (I'll also try my best to help others
)
Thanks,
Paul
I'm currently experiencing some problems with my Access 2000 Database. I'm designing a database for a Youth Football Team you see, but have become a little stuck on something.
In a table I have, I've created a field called DOB. What I want to do, is be able to enter a certain age, but have it be between specific ones.
E.g. If the player is in the U-13's team, and I enter his DOB as 14/12/1987, then an error message will pop up, as that would mean the person would be too old, just the same as it will if I enter something such as 01/04/2000, meaning the player would be too young.
I've tried numerous things to accomplish this, but am constantly failing. I have five tables which I want to use this in, and the one I'm currently testing it in is the Under 12's Team table.
I have tried using this validation rule:
=Now()-[DOB]<12 And Now()-[DOB]>11
Meaning that the player can be no less than the age of 11 but no more than the age of 12. However, it doesn't work whatsoever, because when I enter an erroneous piece of data, it allows it, even though all of my validation is correct.
I'd much appreciate any help that can be provided on this. (I'll also try my best to help others

Thanks,
Paul