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

G

Genio

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)
 
O

Ofer

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

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)
Click to expand...

Try using a criterion

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

John W. Vinson[MVP]
 
Top