Query Search

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Im trying to use the Criteria Field for the Query so i can find a record but I have several companies that have differnt locations for example

Archtech Dallas
Archtech Miami
Groundvette New York
Groundvette Las Vegas

they have differnt company ID's because they are at differnt address at the moment im using the following code in the Criteria field to search for a company

[Forms]![Labels]![Company Name]

But if i want it to bring up a comany i have to type "Archtech Dallas" to bring that company info up. But how do you setup it up to say find everything with just "A" or "Arch" incase you dont know how to spell it.
 
The following will find everything that begins with what is in the Company
Name textbox:
Like [Forms]![Labels]![Company Name] & "*"

This will find everything that contains what is in the Company Name textbox:
Like "*" & [Forms]![Labels]![Company Name] & "*"

This will find everything that ends with what is in the Company Name
textbox:
Like "*" & [Forms]![Labels]![Company Name]


--

Ken Snell
<MS ACCESS MVP>

Larry said:
Im trying to use the Criteria Field for the Query so i can find a record
Click to expand...
but I have several companies that have differnt locations for example
Archtech Dallas
Archtech Miami
Groundvette New York
Groundvette Las Vegas

they have differnt company ID's because they are at differnt address at
Click to expand...
the moment im using the following code in the Criteria field to search for a
company
[Forms]![Labels]![Company Name]

But if i want it to bring up a comany i have to type "Archtech Dallas" to
Click to expand...
bring that company info up. But how do you setup it up to say find
everything with just "A" or "Arch" incase you dont know how to spell it.
 
Hi Larry,

Try [Please enter the company name.] & "*"

HTH
--
-Larry-
--

Larry said:
Im trying to use the Criteria Field for the Query so i can find a record
Click to expand...
but I have several companies that have differnt locations for example
Archtech Dallas
Archtech Miami
Groundvette New York
Groundvette Las Vegas

they have differnt company ID's because they are at differnt address at
Click to expand...
the moment im using the following code in the Criteria field to search for a
company
[Forms]![Labels]![Company Name]

But if i want it to bring up a comany i have to type "Archtech Dallas" to
Click to expand...
bring that company info up. But how do you setup it up to say find
everything with just "A" or "Arch" incase you dont know how to spell it.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Rational Tables? 3
Date search query 0
Wildcard Table 4
Command button?? 2
to Query or VB for pulling criteria from an unbound field 7
List Box search 4
Select Queries 1
Help with a query 2

Back
Top