Kamis, 27 Desember 2018

Re: [MS_AccessPros] Find a customer

 

you're welcome ~ happy to help
~ crystal

VBA code you can use in your projects
http://msaccessgurus.com/code.htm

On 12/27/2018 3:49 PM, Bill.Singer@at-group.net [MS_Access_Professionals] wrote:

Bingo�!!!

That did it.

�

Thank you.

�

Bill Singer

From: MS_Access_Professionals@yahoogroups.com <MS_Access_Professionals@yahoogroups.com>
Sent: Thursday, December 27, 2018 3:01 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Find a customer

�

�

hi Bill,

try this for citeria:

Like "*" & [Forms]![f_ReportsMain]![txtGroupNumber] & "*"

~crystal

VBA code you can use in your projects
http://msaccessgurus.com/code.htm

�

On 12/27/2018 2:24 PM, Bill.Singer@at-group.net [MS_Access_Professionals] wrote:

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: crystal 8 <strive4peace2008@yahoo.com>
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (4)

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.


SPONSORED LINKS
.

__,_._,___

Tidak ada komentar:

Posting Komentar