Search results

I want to create a macro that will export a single query to excel, that can create multiple workbooks from a list. It is not realistic to create individual queries for each item (100+ items and changes often) and need each item in a list in a different worksheet (preferably in the same...

Thanks guys for all the replys.The Like "*" was not getting any information either and using the OR option was not working neither. The OR option was coming up with an conflict error, I guess it was because I had 12 other IIF and LIKE statements in my query. In the end, I had to use my table...

I am using the follow IIF statement and get zero results back - IIf([Forms]![Basic Form]![Pricing Region]="*",True,[Forms]![Basic Form]![Pricing Region]). If I change the True to 15, I get the information from Region 15 to come back, the result I need is all numbers to come back. I have tried...