I have created a union query that counts the number of records that meet different criteria. The query produces just 3 columns of data - Count - Priority - Complxty. Is it possible to do an IF statement on a report to extract one of the pieces of criteria from the union query. eg: If Priority = Medium & Complxty = Low then show the value in the Count column. Any advice is gratefully accepted.