But the same preliminary questions have to be asked:
What version of FileMaker are you using?
How have you designed your data model? What tables, fields, relationships, calculations hold the data you need to reference in order to set up this report?
Have you worked with SQL before?
If memory serves, we've discussed summary reports for you project previously, but I don't dare trust my memory to recall these details accurately (and they may have changed since then anyway).
Using FMP Pro V 13.4
The table in question is called Org's. No relationships involved in this report.
The fields needed to calculate the report are:
- DateOrdered: Date field. (populated only if Org actually purchased one version of our product.)
- DateCancelled: Date field (populated only if Org bought and subsequently cancelled their subscription.)
I have very, very little experience with SQL but eager to use and learn if that's the best way to generate this report.
As I said, I can get the info by manually searching. Find DateOrdered <mm/dd/yyyy AND omit DateCancelled <mm/dd/yyyy but I have to do this for every year starting 2005 and I'm sure this can be done in FMP.
I don't know how to automate this search process starting with a specific month and stepping through on a monthly basis and generate a report? Eventually, I'd like to refine this to summarize this by the different versions of our product. We have about 10.
Thanks for your help.