Table query

Gloria Sulkowski

Can someone help me with running a query on tables?  I'm trying to run a query of our degrees to export and not having any luck with it.

Thanks for any help you can give me.

Alan French

If you just want a list of the table entries, go to Config > Tables and select the Degrees table, then right-click anywhere in the list of degrees and print or preview the Code Tables Report. You can export the list to Excel or CSV formats amongst others.


To know how many times the table entries have been used, you could create a query with criteria "degree not blank", export a list of everyone's degrees and do a pivot table in Excel.


Both reports might be useful - the first won't tell you how frequently each degree type is used, and the second won't include table entries that don't exist on any education records.

Gloria Sulkowski

Thanks so much Alan!  I really appreciate this.