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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Genio - 15 Nov 2005 21:29 GMT

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)

Reply to this Message

Ofer - 15 Nov 2005 21:38 GMT

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

Signature

I hope that helped
Good Luck

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

Reply to this Message

John Vinson - 15 Nov 2005 22:20 GMT

>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]

Reply to this Message