parameter query

[umzsexythang]

Hi,I currently have a parameter query which asks the user to type in the name of a supplier as the parameter, and then the data for that particular supplier appears. If the user wants to view all suppliers instead of just one, how can the query be altered so that they can type in "All" so that all suppliers can be seen?

Hope this makes sense

 

[umzsexythang]

have figured it out, don't worry!

Just used the Is Null function is the Or field