AndyShuter
Registered User.
- Local time
- Today, 11:26
- Joined
- Mar 3, 2003
- Messages
- 151
Iam trying to create a query that returns "grouped" results on demand.
For ecxample, I have a field called "finance companies", Now I know how to filter the results so I can show only one selection, or all of them, but not a selection on demand (God that sounds not very clear!)
In the Citeria box in the query design grid I am putting the following expression
Like "*" & [Forms]![listbox1]![Combo442] & "*"
Whichever Finance Co I select from Combo442 will start the filter, or return all if it is left blank
What I really want to do is be able to create another Combo Box (Say Combo 444) and return the results for that as well as Combo 442, and all if left blank
Jees, I hope I've explained that right
Thanks as ever
Andy
For ecxample, I have a field called "finance companies", Now I know how to filter the results so I can show only one selection, or all of them, but not a selection on demand (God that sounds not very clear!)
In the Citeria box in the query design grid I am putting the following expression
Like "*" & [Forms]![listbox1]![Combo442] & "*"
Whichever Finance Co I select from Combo442 will start the filter, or return all if it is left blank
What I really want to do is be able to create another Combo Box (Say Combo 444) and return the results for that as well as Combo 442, and all if left blank
Jees, I hope I've explained that right
Thanks as ever
Andy
