Consider the following Query and returned data.
SELECT lkp_VolSubFields.FldName AS [Section], lkp_VolSubFields.ImportFile AS [File], lkp_VolSubFields.PlanSubTypeCD as [Type]
ORDER BY lkp_VolSubFields.FldName,lkp_VolSubFields.ImportFile;
Section File Type
Roth Transfers Other Provisions K
Roth Transfers Other Provisions P
Years of Service Other Provisions K
Age of Service Eligibility K
Age of Service Eligibility P
I want the report to look like this:
Section File 401K PS
Roth Transfers Other Provisions Y Y
Years of Service Other Provisions Y
Age of Service Eligibility Y Y
ImportFile and FldName can be duplicate (but no more than 2 records).
I know I need to do the aggregate functions on some fields but I'm not sure how to create the temporary (variable) fields based on the values of "K" or "P" from the PlanSubTypeCd [Plan]. The values do not have to be "Y" or "N", they can be boolean.
Can this be done in an Access query?