Parementer Queries

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

Guest

I'm trying to build a search query ....lets say in my table, under Vendor
Name, I have 5 records the read...ABB, ABB House, ABB Record, ABB Car, ABB
Form.

When I use this Parementer [Search Name] in my query, I put in ABB, I'm not
getting any records, but when I put in ABB House, I get that one record.

How come its not giving me all records with ABB in it?

Thank you in advance for your help

Tim
 
If you are not getting ABB, then either it is not really ABB, or there is
some other cirteria filtering that record out. To get all the records that
start with ABB, use
LIKE "ABB*"
 
Thank you for your reply Klatuu. How would I apply that to the Parementer
field...I already tried...Like [Enter Search].

Klatuu said:
If you are not getting ABB, then either it is not really ABB, or there is
some other cirteria filtering that record out. To get all the records that
start with ABB, use
LIKE "ABB*"

Tim said:
I'm trying to build a search query ....lets say in my table, under Vendor
Name, I have 5 records the read...ABB, ABB House, ABB Record, ABB Car, ABB
Form.

When I use this Parementer [Search Name] in my query, I put in ABB, I'm not
getting any records, but when I put in ABB House, I get that one record.

How come its not giving me all records with ABB in it?

Thank you in advance for your help

Tim
Click to expand...
Click to expand...
 
When the Enter Search box pops up, type in ABB*

Tim said:
Thank you for your reply Klatuu. How would I apply that to the Parementer
field...I already tried...Like [Enter Search].

Klatuu said:
If you are not getting ABB, then either it is not really ABB, or there is
some other cirteria filtering that record out. To get all the records that
start with ABB, use
LIKE "ABB*"

Tim said:
I'm trying to build a search query ....lets say in my table, under Vendor
Name, I have 5 records the read...ABB, ABB House, ABB Record, ABB Car, ABB
Form.

When I use this Parementer [Search Name] in my query, I put in ABB, I'm not
getting any records, but when I put in ABB House, I get that one record.

How come its not giving me all records with ABB in it?

Thank you in advance for your help

Tim
Click to expand...
Click to expand...
Click to expand...
 
Thanks Klatuu...that will work :)

Klatuu said:
When the Enter Search box pops up, type in ABB*

Tim said:
Thank you for your reply Klatuu. How would I apply that to the Parementer
field...I already tried...Like [Enter Search].

Klatuu said:
If you are not getting ABB, then either it is not really ABB, or there is
some other cirteria filtering that record out. To get all the records that
start with ABB, use
LIKE "ABB*"

:

I'm trying to build a search query ....lets say in my table, under Vendor
Name, I have 5 records the read...ABB, ABB House, ABB Record, ABB Car, ABB
Form.

When I use this Parementer [Search Name] in my query, I put in ABB, I'm not
getting any records, but when I put in ABB House, I get that one record.

How come its not giving me all records with ABB in it?

Thank you in advance for your help

Tim
Click to expand...
Click to expand...
Click to expand...
 
Klatuu...the ABB* didn't work either..I'm sorry....I'm can't think of
anything else.

Tim said:
Thanks Klatuu...that will work :)

Klatuu said:
When the Enter Search box pops up, type in ABB*

Tim said:
Thank you for your reply Klatuu. How would I apply that to the Parementer
field...I already tried...Like [Enter Search].

:

If you are not getting ABB, then either it is not really ABB, or there is
some other cirteria filtering that record out. To get all the records that
start with ABB, use
LIKE "ABB*"

:

I'm trying to build a search query ....lets say in my table, under Vendor
Name, I have 5 records the read...ABB, ABB House, ABB Record, ABB Car, ABB
Form.

When I use this Parementer [Search Name] in my query, I put in ABB, I'm not
getting any records, but when I put in ABB House, I get that one record.

How come its not giving me all records with ABB in it?

Thank you in advance for your help

Tim
Click to expand...
Click to expand...
Click to expand...
 
I don't know what to tell you. I tested it and it works for me.

Tim said:
Klatuu...the ABB* didn't work either..I'm sorry....I'm can't think of
anything else.

Tim said:
Thanks Klatuu...that will work :)

Klatuu said:
When the Enter Search box pops up, type in ABB*

:

Thank you for your reply Klatuu. How would I apply that to the Parementer
field...I already tried...Like [Enter Search].

:

If you are not getting ABB, then either it is not really ABB, or there is
some other cirteria filtering that record out. To get all the records that
start with ABB, use
LIKE "ABB*"

:

I'm trying to build a search query ....lets say in my table, under Vendor
Name, I have 5 records the read...ABB, ABB House, ABB Record, ABB Car, ABB
Form.

When I use this Parementer [Search Name] in my query, I put in ABB, I'm not
getting any records, but when I put in ABB House, I get that one record.

How come its not giving me all records with ABB in it?

Thank you in advance for your help

Tim
Click to expand...
Click to expand...
Click to expand...
 
Thanks for still writing Klatuu!

I don't know either, if it works for you, I wonder if I have something else
wrong...hmmmm. I guess just thank you again...I don't know anymore!

Klatuu said:
I don't know what to tell you. I tested it and it works for me.

Tim said:
Klatuu...the ABB* didn't work either..I'm sorry....I'm can't think of
anything else.

Tim said:
Thanks Klatuu...that will work :)

:

When the Enter Search box pops up, type in ABB*

:

Thank you for your reply Klatuu. How would I apply that to the Parementer
field...I already tried...Like [Enter Search].

:

If you are not getting ABB, then either it is not really ABB, or there is
some other cirteria filtering that record out. To get all the records that
start with ABB, use
LIKE "ABB*"

:

I'm trying to build a search query ....lets say in my table, under Vendor
Name, I have 5 records the read...ABB, ABB House, ABB Record, ABB Car, ABB
Form.

When I use this Parementer [Search Name] in my query, I put in ABB, I'm not
getting any records, but when I put in ABB House, I get that one record.

How come its not giving me all records with ABB in it?

Thank you in advance for your help

Tim
Click to expand...
Click to expand...
Click to expand...
 
I tried it both ways and both returned identical results. Tim must have
something else going on in the query, or the data he is looking at is not
what it appears to be.
 
Thank you very much SusanP....It works like a charm!!!!!!!

thank you too Klatuu...maybe it's because I'm in a different version or
something, I'm not sure...but thank you anyway, you have been most helpful as
well!!!

Again, thank you both greatly :)
 
Back
Top