I have two long integer fields: YouthNbr and AdultNbr. I need to calculate the ration of Youth To Adults.
e.g. Youth = 8, Adults = 2, Ratio = 4:1 displayed this way.
I want to do this in an Event using VBA, not using a Query.
How do I do it? Is there a Function?