A Gold Mine customer asked: How do I use a SQL Query to create a group?
First, run your SQL Query so the results are on the screen: Tools > Filters and Groups > SQL Query tab.
Switch to the Groups tab > Click on New Group.
Enter a Group Name.
Code field can be used for anything you'd like. Since Groups are
static, i.e. they do not automatically update, it’s a good idea to put
in the date they're created so you know at a glance when the group was
Be sure the Build Group box is checked, click OK.
the Group Building Wizard, click the SQL Query Records radio button.
(If this is grayed out it means there is nothing appearing in the SQL
Choose whether and how to sort
your group, if you want any fields brought over into the Reference
field, and if you need to limit the size of the group.
Click Next > Finish.