start count after 3rd. record.

[David Odom]

Hi, I would like to count records in a field beginning with the 4th. record. I now have this in a text box: =Count([VisitDate]) , but I need to start the count AFTER the 3rd. visit date to get a total of the remaining visits. Thank you for your help. David

 

[Ron Weiner]

David Odom has brought this to us :

Hi, I would like to count records in a field beginning with the 4th. record.
I now have this in a text box: =Count([VisitDate]) , but I need to start the
count AFTER the 3rd. visit date to get a total of the remaining visits. Thank
you for your help. David

Ummm... =iif(Count([VisitDate])> 3, Count([VisitDate]) - 3, 0)

Rdub

 

[David Odom]

David Odom has brought this to us :

Hi, I would like to count records in a field beginning with the 4th. record.

I now have this in a text box: =Count([VisitDate]) , but I need to start the

count AFTER the 3rd. visit date to get a total of the remaining visits. Thank

you for your help. David

Ummm... =iif(Count([VisitDate])> 3, Count([VisitDate]) - 3, 0)



Rdub

Thank you Ron, this works perfectly! David