Guest_imported
New member
- Jan 1, 1970
- 0
Excuse me,<br> I want to calculate the age of a client, while i have their birthday, HOWEVER, this age needs to be placed into a criteria. say if the man is 45, he would fit under the age group of 40 to 50 and that column would have a checkbox under it. My table however only uses the b-day instead of their age so that when i view the data in my report, it will display the most current calculated age. Basically, the age will use be calculated from the birthday and the current date. My Problem is creating the procedure to calculate it and placing it into the correct column/criteria group. Can you help me with this problem? Does it make sense?<br>Jim Smitty<br><A HREF="mailto:jimschmitty@hotmail.com">jimschmitty@hotmail.com</A>