start count after 3rd. record.

D

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
 
R

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
 
D

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top