I’m using Access 2007 and have a query referencing an Option Group on a Form as a filter. The Option Group has 3 choices: Billable Manhours (value = 1), Non Billable Manhours (value = 2), All Manhours (value = 3). My query statement is:
When All Manhours is selected (value = 3), I want to return all values, whether True or False. I can’t figure out what to place in my last False element to return all records. I've tried "", Is Not Null, and other things, but returns an error message or no records.
May 6, 2009 8:39 PM
May 7, 2009 3:08 PM