Dezirous
Rafi Ahmed
- Local time
- Today, 13:40
- Joined
- Jul 8, 2009
- Messages
- 71
Hi eXperts........
I've a select query with criteria = department, when I select any one department at a time from my combo box, it shows records from that department.
Now I want to insert "All Department" option in combo box to show records from all department, not specific department. I don't know how to use IIF in query or somewhere else......
Plz help......... and many thanks in advance.........
I've a select query with criteria = department, when I select any one department at a time from my combo box, it shows records from that department.
Now I want to insert "All Department" option in combo box to show records from all department, not specific department. I don't know how to use IIF in query or somewhere else......
Plz help......... and many thanks in advance.........