AnsweredAssumed Answered

Filemaker pro 10 question

Question asked by WayneMORRELL on Nov 10, 2013
Latest reply on Nov 11, 2013 by WayneMORRELL


Filemaker pro 10 question


     Hi, probably another stupid question from a newbie.

     I have a company with a loyalty system, so every 6th visit you get free service...nice...

     So I have a field counting the visits, so Client Count equals Count(Event:Name).

     Now what Im thinking is just to divide the count by 6, if the result is a whole number then YES (Its a free service visit) if the result is not a whole number then NO (sorry your picking up the bill for this visit).

     Ive lost a couple of hours trying to figure this with the number functions but can't get it.

     Im sure you guys will figure this instantly, Id appreciate your help




     Wayne from Oz