2 Replies Latest reply on Nov 11, 2013 7:30 AM by WayneMORRELL

    Filemaker pro 10 question



      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