I am new to FileMaker Pro, so this may have an obvious answer that I'm just not seeing.
I would like to have a layout that gives some basic statistics regarding my database.
For example, there is a 'student' table that contains (among others) columns for last_name, first_name, and district_name.
There are 5,000+ records, and several different districts represented.
On the layout, I would like to have something along the lines of:
|District Name||# Records||% of Total|
Perhaps there is a really simple way to do this? I was attempting to use ExecuteSQL, but am getting mixed results. Using Data Viewer I have the following:
ExecuteSQL ( "SELECT COUNT(*) FROM Student where ST_District='District A' " ; "" ; "" )
This correctly gives me a result of 900. However, when I copy and paste this exact code into a calculation field, then place it onto the layout, all I get is the question mark.
So, I suppose my question is actually two questions...
1) Why does the ExecuteSQL code work in Data Viewer, but not as an actual field and
2) Is there a better approach to creating the table as described above.