By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,501 Members | 2,861 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,501 IT Pros & Developers. It's quick & easy.

paramter query question

P: 53
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
Jan 9 '08 #1
Share this Question
Share on Google+
3 Replies


ADezii
Expert 5K+
P: 8,638
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
Expand|Select|Wrap|Line Numbers
  1. Like [Enter Vendor Name] & "*"
Jan 9 '08 #2

P: 53
Thanks,

That is what I needed.

Much appreciated,
Lance
Jan 9 '08 #3

ADezii
Expert 5K+
P: 8,638
Thanks,

That is what I needed.

Much appreciated,
Lance
Anytime we can help, Lance.
Jan 10 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.