What can I enter in a promp criteria for the query to show all?

[Guest]

I have made a Query out of a list of clients and have also selected a
"criteria" [Please Input Last Name:] but what if I whant to see the complete
list? What can I write so that the query will show all the data? (meaning,
not filtered)

 

[Guest]

Try this
SELECT TableName.*
FROM TableName
WHERE TableName.FieldName Like IIf([Please Input Last Name:] Is
Null,"*",[Please Input Last Name:])

 

[John Vinson]

I have made a Query out of a list of clients and have also selected a
"criteria" [Please Input Last Name:] but what if I whant to see the complete
list? What can I write so that the query will show all the data? (meaning,
not filtered)

Try using a criterion

= [Please Input Last Name:] OR [Please Input Last Name:] IS NULL

John W. Vinson[MVP]