just to be sure, because sometimes things aren't what we think...
are there records in the table that did not have that test, and so do not have a time stamp?
are the records filtered so that only people having the test are included, or at least the counting part?
To debug, you could display the formula in the detail section of the report and then you could see where CR is assigning a 1, and if the logic is correct.
It can be hard to debug black boxes as we can't see what / CR is doing something that we think is wrong...but is what we told it to do.
As hilfy's tag line reads, "Computers only do what you tell them, not what you thought you told them."
HTH
IP Logged
