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

querying similar records

P: 2

I'm trying to set up a query which prompts user for an input, store in a new field, and then find similar records. For example,

User Input: B1-346 and stored in [OrderNumberInput]
Query return: all records with [OrderNumber] equal to B1-346, B1-346-01, B1-346-02, etc.

How would I establish this? Please help!

Aug 14 '06 #1
Share this Question
Share on Google+
2 Replies

Expert Mod 10K+
P: 14,534
In the Criteria Section under the column for [OrderNumberInput] enter the following:

Like [Please enter xxx: ] & "*"
Aug 14 '06 #2

P: 2
You're wonderful!! Appreciate much!
Aug 15 '06 #3

Post your reply

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