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

Outcomes