paramter query question

[araman]

i have a simple paramter query. one of the fields is called vendors.
the criteria is "Like [Enter Vendor or * for All]
is there a way to construct the query in which "like [ enter Vendor name] "
but if it is left blank then all record are returned.

Thanks

Lance

[ADezii]

i have a simple paramter query. one of the fields is called vendors.
the criteria is "Like [Enter Vendor or * for All]
is there a way to construct the query in which "like [ enter Vendor name] "
but if it is left blank then all record are returned.

Thanks

Lance

Like [Enter Vendor Name] & "*"

[araman]

Thanks,

That is what I needed.

Much appreciated,
Lance

[ADezii]

Thanks,

That is what I needed.

Much appreciated,
Lance

Anytime we can help, Lance.