Microsoft Query - Return all unless a parameter is entered

Hi all,

could someone help with this please..

I am querying a database in Microsoft Query and I have it set to pull in jobs that match a customers code in cell A1. I would like it so that if cell A1 is blank, it pulls in jobs for every customer.

Could someone advise please? My code is below..

Please Login or Register  to view this content.

Thanks
John

I think it would be something like:

Please Login or Register  to view this content.

Then in another cell in the sheet use formula:

="%"&A1&"%"

and reference that cell as a Parameter.

You are welcome,

Please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save