If statement in a report's text box

coach.32

Registered User.
Local time
Tomorrow, 03:59
Joined
Aug 14, 2011
Messages
28
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.
 
Along the lines of

IIf(Priority = "Medium" AND Complxty = "Low", 1, 0)
 
hello people!
 

Users who are viewing this thread

Back
Top Bottom