|I tried and have researched this puzzle but I give in. I need some professional help..|
I wish to run a simple MS Access query for a list of records with an "Active" and "Closed" field. I am not the best VB guy in the world (still reading the "Dummy" book).
I tried to use IIf([Enter Status]="Active","Active",Null)or IIf([Enter Status]="Closed","Closed",Null) or IIf([Enter Status]="All",Like "[a-Z*]",Null) in the select query window. I tried the "not like" etc functions, but none seem to work.
I wish to show all records if the entry "All" is applied. It's probably really simple, but its making me bald... please aid. Thanks, Mark