Query Criteria Help

[mattc66 via AccessMonster.com]

I have my query prompt the user for entry. [USER INPUT] I want to all them to
enter data, but if left blank I'd like it to show all data. How would I
change the criteria?

Thanks
Matt

 

[Jerry Whittle]

Like [USER INPUT] & "*"

The above could cause problems if someone just wanted to see "Base" as it
would also return "Bases" and "BaseBall".

 

[mattc66 via AccessMonster.com]

What if the user leaves it blank. I want it to show all including if the
field is blank.

Like [USER INPUT] & "*"

The above could cause problems if someone just wanted to see "Base" as it
would also return "Bases" and "BaseBall".

I have my query prompt the user for entry. [USER INPUT] I want to all them to
enter data, but if left blank I'd like it to show all data. How would I
change the criteria?

Thanks
Matt

 

[Jerry Whittle]

Try the following:

Like [USER INPUT] & "*" Or Is Null
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

What if the user leaves it blank. I want it to show all including if the
field is blank.

Like [USER INPUT] & "*"

The above could cause problems if someone just wanted to see "Base" as it
would also return "Bases" and "BaseBall".

I have my query prompt the user for entry. [USER INPUT] I want to all them to
enter data, but if left blank I'd like it to show all data. How would I
change the criteria?

Thanks
Matt

 

[John W. Vinson]

What if the user leaves it blank. I want it to show all including if the
field is blank.

Try it.

John W. Vinson [MVP]

 

[John Spencer]

If you wanted an exact match or if the prompt was left blank all records
with a value in the field, try the criteria

Like NZ([USER INPUT],"*")

If the field can contain null values and you want all the records if the
user leaves the criteia blank, then try

Field: Whatever
Criteria: = [User Input] or [User Input] is Null

--
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
..

Like [USER INPUT] & "*"

The above could cause problems if someone just wanted to see "Base" as it
would also return "Bases" and "BaseBall".
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.

I have my query prompt the user for entry. [USER INPUT] I want to all
them to
enter data, but if left blank I'd like it to show all data. How would I
change the criteria?

Thanks
Matt