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