Log in

View Full Version : Query syntax


IvyKeepMommy
05-16-2008, 06:40 PM
I'm still learning about databases and something has come up that I need to check the average age of our membership (not an individual member's age, but the overall average) as part of registration, everyone is required to provide their year of birth... can anyone tell me what query I would use that would either just list the year of birth (not attached to names) or that could calculate the average age of the membership population?

Boofo
05-16-2008, 08:00 PM
<a href="https://vborg.vbsupport.ru/showpost.php?p=596879&postcount=4" target="_blank">https://vborg.vbsupport.ru/showp...79&postcount=4</a>

IvyKeepMommy
05-16-2008, 09:47 PM
Thanks Boofo! You are the best!!

Boofo
05-16-2008, 10:38 PM
Awww, you're just saying that because it's true. ;)

Glad I could help. ;)