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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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)
 
Try this
SELECT TableName.*
FROM TableName
WHERE TableName.FieldName Like IIf([Please Input Last Name:] Is
Null,"*",[Please Input Last Name:])
 
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]
 
Back
Top