I am having difficulties to make a query to work. I have a filemaker table called demo. Within that table, I have 3 fields: name, paymenttype (cash or credit card) and dateofpurchase.
I need to count the number of persons paying by credit card over the las 30 days.
My attempt was the following, but is not working:
ExecuteSQL ( "SELECT COUNT \"demo\".\"paymenttype\" ) FROM \"demo\"" WHERE paymenttype = "credit card" )
Thank you very much!!!!
PS: I am using FM 16 for Windows