you're welcome ~ happy to help
~ crystal
VBA code you can use in your projects
http://msaccessgurus.com/code.htm
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) |
Tidak ada komentar:
Posting Komentar