I have a query that I would like to have a calculated field called GROUP whose values are based on another field. For Example, if field CODE1 = A, B, or C then GROUP = "First". If field CODE1 = C or D or F, then the GROUP = "second" and so on. This would apply for each record to assign which group they would be in.
I only have four groups and I am pulling data from a mainframe report. The query seems to be the most direct since I am cutting and pasting the info into a spreadsheet for mgt to view however they wish. Any help with syntax appreciated