AnsweredAssumed Answered

SQL GROUP BY ISSUE

Question asked by MorkAfur on Dec 4, 2014
Latest reply on May 10, 2016 by beverly

Summary

SQL GROUP BY ISSUE

Product

FileMaker Pro

Version

13 v04

Operating system version

Mac 10.10.1

Description of the issue

GROUP BY DID NOT WORK AS EXPECTED

http://forums.filemaker.com/posts/eb7a47380c?commentId=312864#312864

Steps to reproduce the problem

http://forums.filemaker.com/posts/eb7a47380c?commentId=312864#312864

Expected result

Counts by year.

Actual result

"?" in Data Viewer

http://forums.filemaker.com/posts/eb7a47380c?commentId=312864#312864

Workaround

Had to create an extra "helper" count field to use in the SQL.

Outcomes