AnsweredAssumed Answered

SQL query error

Question asked by pablosabat on Mar 12, 2019
Latest reply on Mar 15, 2019 by beverly

Dear all:


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