[MS_AccessPros] Find a customer

 

I am on Window 10, Access 365

 

I am trying to write a query that finds a customer based on a policy number.   Initially his worked fine and the results were returned in a form with the policy number and the customer number.

 

The difficulty I am having is when I only know part of the policy number.

 

The query pulls the policy number from a text box on a form and searches a table for the customer. The results are displayed in a pop up form.

If I type the policy number into the Criteria box of the query such as  “31090”   the query runs fine.

If I type the policy number into the Criteria box of the query such as   Like ”*31090*”   the query runs fine.  This catches complete and partial policy numbers.

If I reference the text box on the form such as    [Forms]![f_ReportsMain]![txtGroupNumber]    the query runs fine, but it only catches complete policy numbers.

 

However, when I put in       Like "*[Forms]![f_ReportsMain]![txtGroupNumber]*"     to try to search for complete or partial matches the query returns  zero results.

 

What am I doing wrong to be able to search for partial or complete policy numbers.

 

Thank you.

 

Bill Singer

Minnesota

__._,_.___

---

Posted by: <Bill.Singer@at-group.net>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (1)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 2
• New Photos 1

• Privacy • Unsubscribe • Terms of Use

SPONSORED LINKS

.

__,_._,___