Recent content by AstroNut

  1. A

    Access 2007 - Conditional Criteria in Query

    I had to solve a Yes/No parameter problem for a field called VIPEvent. I finally remembered Access telling me earlier that -1 was Yes and 0 was No. However, I really didn't want users typing those values in, so I added a non-displaying column to my query: IIf([VIPEvent]=-1,"Yes","No") This...