I have written an If statement to allow me to display (on a report) which box was selected on a Form:
=IIf(Forms![Main Menu]!OpenCheck=-1,"Open","") & IIf(Forms![Main Menu]!ClosedCheck=-1,"Closed","")
This currently displays 'Open', 'Closed', or 'OpenClosed'
I want it to display 'Open', 'Closed', or 'Open and Closed'