Wildcards and Default Values

[bwwood]

Hello,
I have a form that asks for input, and a query that pulls the input from that form and generates a report based on variables the user can control.
Here is the criteria I am currently using:

one is to input a range of dates...
Is Not Null And Between [Forms]![Input-Incident Log]![BeginDate] And [Forms]![Input-Incident Log]![EndDate]

The other is for input of a system name...
[Forms]![Input-Incident Log].[SysAff]

These both work great, as long as something is entered into each field.
In the form the user inputs variables, I would like to have a default value ( * maybe?) that basically tells the query, if no input is made, show all data for this record.
I have tried
[Forms]![Input-Incident Log].[SysAff] Or Like "*"
and a couple other things similar. basically what happens is the report returns no data.

I am sure this is pretty easy, but I am a newbie in Access and I am still cutting my teeth.
Thank you in advance for any help you can provide.

 

[JerryDennison]

Try:
Like [Forms]![Input-Incident Log].[SysAff] & "*"

 

[bwwood]

Thank you Jerry, That worked!

 

[JerryDennison]

Imagine that! You're welcome.