Criteria

[Guest]

i want to be able to pull up info from a certian company. Haw do i code it to
search for this company. My previous criteria wsa [Company Name] which meant
that you had to spell the name exactly as it is written is ther a way so that
i am able to enter just the first few letters instead of the entire name. Or
is there something else i sholud be doing?

 

[fredg]

i want to be able to pull up info from a certian company. Haw do i code it to
search for this company. My previous criteria wsa [Company Name] which meant
that you had to spell the name exactly as it is written is ther a way so that
i am able to enter just the first few letters instead of the entire name. Or
is there something else i sholud be doing?

Like [Enter Company Name] & "*"

If you enter Smi the query will return records that begin with the
letters smi, i.e. 'Smith and Sons', 'Smiling Creations Inc.', etc.

Like "*" & [Enter Company Name] & "*"
If you enter Smi the query will return records that contain smi
anywhere in the field, i.e. 'Smith and Sons', 'The Smithers Company',
'Johnson and Jasmine', etc.

The more letters you enter the narrower the selection of returned
records will be.

A better solution would be to use a combo box on a form to select the
exact company you want. Post back if you want help on that.
The method is a bit different if the query is actually used as the
record source for a report.

 

[benbanyas]

i want to be able to pull up info from a certian company. Haw do i code it to
search for this company. My previous criteria wsa [Company Name] which meant
that you had to spell the name exactly as it is written is ther a way so that
i am able to enter just the first few letters instead of the entire name. Or
is there something else i sholud be doing?

Like [Enter Company Name] & "*"

If you enter Smi the query will return records that begin with the
letters smi, i.e. 'Smith and Sons', 'Smiling Creations Inc.', etc.

Like "*" & [Enter Company Name] & "*"
If you enter Smi the query will return records that contain smi
anywhere in the field, i.e. 'Smith and Sons', 'The Smithers Company',
'Johnson and Jasmine', etc.

The more letters you enter the narrower the selection of returned
records will be.

A better solution would be to use a combo box on a form to select the
exact company you want. Post back if you want help on that.
The method is a bit different if the query is actually used as the
record source for a report.

 

[benbanyas]

I guess the original poster and myself are having similar problems. This
advice helped me, but I am also having problems with ComboBoxes. If I have 3
of the same(Such as three things from "Ben Banyas") in my Source Column how
do I make the ComboBox only show "Ben Banyas" once in the drop down list and
not 3 times?
Thanks!

i want to be able to pull up info from a certian company. Haw do i code it to
search for this company. My previous criteria wsa [Company Name] which meant
that you had to spell the name exactly as it is written is ther a way so that
i am able to enter just the first few letters instead of the entire name. Or
is there something else i sholud be doing?

Like [Enter Company Name] & "*"

If you enter Smi the query will return records that begin with the
letters smi, i.e. 'Smith and Sons', 'Smiling Creations Inc.', etc.

Like "*" & [Enter Company Name] & "*"
If you enter Smi the query will return records that contain smi
anywhere in the field, i.e. 'Smith and Sons', 'The Smithers Company',
'Johnson and Jasmine', etc.

The more letters you enter the narrower the selection of returned
records will be.

A better solution would be to use a combo box on a form to select the
exact company you want. Post back if you want help on that.
The method is a bit different if the query is actually used as the
record source for a report.