Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

start count after 3rd. record.

12 views
Skip to first unread message

David Odom

unread,
Nov 6, 2012, 7:34:22 PM11/6/12
to
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

unread,
Nov 7, 2012, 9:46:33 PM11/7/12
to
David Odom has brought this to us :
Ummm... =iif(Count([VisitDate])> 3, Count([VisitDate]) - 3, 0)

Rdub


David Odom

unread,
Nov 8, 2012, 12:57:06 PM11/8/12
to
Thank you Ron, this works perfectly! David
0 new messages