Calculating Ranges of Values 2

[benesch]

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.

 

[Golom]

If you simply want to truncate any fractional parts from the age then use

   Int ([Resident Age])

rather than just [Resident Age]

 

[GoDawgs]

The Int function always rounds down (Int(64.7) = 64)...so that may be good enough to solve your problem. Hope that helps.

Kevin

 

[benesch]

Thanks to both of you. Your suggestion solved my problem.