Hi:
I am using a table containing birth dates of assisted living facility residents. I calculate each person's age using a query. The result is calculated out to 13 decimal places. I need to calculate the number of residents whose age falls into specified ranges:
<60, >= 60 and < 65, >=65 and < 70, etc.
I used the Partition function: Partition([Resident Age], 60,5, 100). The problem that I am having is tha, for example, a resident aged 64.7 is rounded to 65, and is treated as falling in the >=65 and < 70 category. I would like such a resident to be counted in the >=60 and < 65 category. I would be very grateful for any suggestions.
I am using a table containing birth dates of assisted living facility residents. I calculate each person's age using a query. The result is calculated out to 13 decimal places. I need to calculate the number of residents whose age falls into specified ranges:
<60, >= 60 and < 65, >=65 and < 70, etc.
I used the Partition function: Partition([Resident Age], 60,5, 100). The problem that I am having is tha, for example, a resident aged 64.7 is rounded to 65, and is treated as falling in the >=65 and < 70 category. I would like such a resident to be counted in the >=60 and < 65 category. I would be very grateful for any suggestions.