I am using Microsoft Query within Excel to source some reports feeding from an access table.
I wanted to put filters on the data and have setup a feed that picks the filter criteria from another sheet within the excel workbook which works fine.
My problem is:
What if I want to show all records in the query and apply no filter? Based on the current configuration if I leave the cells that determine the filters blank then the query returns nothing. I thought by using "*" that might pull everything but it doesn't seem to.
I'm sure it must be simple!!!