ptinreston

Errata — FileMaker Training Series 4 — Module 7 — Reports

Discussion created by ptinreston on Nov 5, 2012

Chapter 7.3

Example 7.3.3

Step 5

 

The "DateOrdered" field references in the third (and fourth) line of the specified formula should be enclosed in escaped quotation marks, as is the _kf_CustomerID field reference. Not doing so yields a blank chart.

 

More specifically...

 

SQL = “Select Sum (Total) from ”Order” Where

”_kf_CustomerID” = ? and DateOrdered>= ? and DateOrdered<= ?”];

 

should be

 

SQL = “Select Sum (Total) from ”Order” Where

”_kf_CustomerID” = ? and "DateOrdered">= ? and "DateOrdered"<= ?”];

 

I believe this is because the field reference in this case is part of an SQL query, rather than a field reference in a FileMaker calculation.

 

I invite and welcome your comments.

 

Phil Toll

Outcomes