<div>
You want <b>Like &quot;*&quot; &amp;&nbsp;[Enter Location:] &amp;&nbsp;&quot;*&quot;</b>
</div>


You want Like "*" & [Enter Location:] & "*"

wlasner

<div>
Worked perfect.<br />
Thank you
</div>


<div>
<div class="content wysiwyg-content">
Microsoft Access 2016<br />
I want to define a parameter query to ask for a selection but return all records if left blank.<br />
I am using Like [Enter Location] .... this works fine. but there are times I want to run the report for all locations.<br />
I tried like [Enter Location] or Like * but this did not work.<br />
<br />
Any suggestions would be greatly appreciated.<br />
thanks<br />
Wayne
</div>
</div>


Microsoft Access 2016
I want to define a parameter query to ask for a selection but return all records if left blank.
I am using Like [Enter Location] .... this works fine. but there are times I want to run the report for all locations.
I tried like [Enter Location] or Like * but this did not work.

Any suggestions would be greatly appreciated.
thanks
Wayne

Define a parameter query to ask for a selection but return all records if left blank

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.