C
Chris Gorham
Hi,
I'm battling here...
I'm trying to write a simple querie that selects either an individual region
or all regions. The source of the selection is a drop down in a form.
Here is the if statment in the qeurie:
IIf([forms]![Main Menu]![Region_Select]<>"All Regions",[forms]![Main
Menu]![Region_Select],Like "*")
I can get it to work when selecting an individual region - no probs. However
when selecting "All Regions" then ideally I just wanted a wild card search
that would include everything.
The regions themselves have variable number of characters and are sometimes
2 words...but try as I might I cannot get this to work...
Any help appreciated...Chris
I'm battling here...
I'm trying to write a simple querie that selects either an individual region
or all regions. The source of the selection is a drop down in a form.
Here is the if statment in the qeurie:
IIf([forms]![Main Menu]![Region_Select]<>"All Regions",[forms]![Main
Menu]![Region_Select],Like "*")
I can get it to work when selecting an individual region - no probs. However
when selecting "All Regions" then ideally I just wanted a wild card search
that would include everything.
The regions themselves have variable number of characters and are sometimes
2 words...but try as I might I cannot get this to work...
Any help appreciated...Chris