Dear Sirs, can someone please help! I am putting together a genealogy database. In my query, I have an age calculation which works fine, my issue is that I do not want some of my age numbers to be shown on my Form for the people who have passed away. Only the people living. I have a checkbox for "Living/Died". Can anyone give me the query calculation to allow me to tie up the checkbox and age calculation?
I am a novice at Access Database, and a bit long in the tooth, but am enjoying the challenge of Access. Thank you.