querying by first few letters

[Guest]

I made a query a while back that allowed me to return all the values that
started with the letters I entered on a form I used to query. Does anyone
have any idea how I might do this. for example I enter "car" and it returns
carter and carpenter and caravelli. I know I need something in the criteria
of the query I just dont know what it is.

Thanks
nick

 

[Joseph Meehan]

I made a query a while back that allowed me to return all the values that
started with the letters I entered on a form I used to query. Does anyone
have any idea how I might do this. for example I enter "car" and it
returns
carter and carpenter and caravelli. I know I need something in the
criteria
of the query I just dont know what it is.

Thanks
nick

From the Access help file.

Expression Result
"London" For a ShipCity field, orders shipped to London
"London" Or "Hedge End" For a ShipCity field, orders shipped to London
or Hedge End

="N" For a CompanyName field, orders shipped to companies whose name

starts with the letters N through Z
Like "S*" For a ShipName field, orders shipped to customers whose name
starts with the letter S (ANSI-89)
Like "S%" For a ShipName field, orders shipped to customers whose name
starts with the letter S (ANSI-92)
Right([OrderID], 2) = "99" For an OrderID field, orders with ID values
ending in 99
Len([CompanyName]) > Val(30) For a CompanyName field, orders for
companies whose name is more than 30 characters long

 

[Guest]

None of that is relavent to the criteria I need, as far as I can tell. I
appreciate it though.

I made a query a while back that allowed me to return all the values that
started with the letters I entered on a form I used to query. Does anyone
have any idea how I might do this. for example I enter "car" and it
returns
carter and carpenter and caravelli. I know I need something in the
criteria
of the query I just dont know what it is.

Thanks
nick

From the Access help file.

Expression Result
"London" For a ShipCity field, orders shipped to London
"London" Or "Hedge End" For a ShipCity field, orders shipped to London
or Hedge End

="N" For a CompanyName field, orders shipped to companies whose name

starts with the letters N through Z
Like "S*" For a ShipName field, orders shipped to customers whose name
starts with the letter S (ANSI-89)
Like "S%" For a ShipName field, orders shipped to customers whose name
starts with the letter S (ANSI-92)
Right([OrderID], 2) = "99" For an OrderID field, orders with ID values
ending in 99
Len([CompanyName]) > Val(30) For a CompanyName field, orders for
companies whose name is more than 30 characters long

 

[Joseph Meehan]

None of that is relavent to the criteria I need, as far as I can tell. I
appreciate it though.

You enter car and what you do want returned? Do you want ONLY those
that contain "car" only those that start with "car" only those that have
"car as a separate text?

I pasted the general instructions as that would answer most questions
and I am not sure of what your question really is. I guess Access does not
know either.

You may want to search on "criteria" in the Access help file. There is
additional help there.

Thanks
nick

From the Access help file.

Expression Result
"London" For a ShipCity field, orders shipped to London
"London" Or "Hedge End" For a ShipCity field, orders shipped to
London or Hedge End

="N" For a CompanyName field, orders shipped to companies whose

name
starts with the letters N through Z
Like "S*" For a ShipName field, orders shipped to customers whose
name starts with the letter S (ANSI-89)
Like "S%" For a ShipName field, orders shipped to customers whose
name starts with the letter S (ANSI-92)
Right([OrderID], 2) = "99" For an OrderID field, orders with ID
values ending in 99
Len([CompanyName]) > Val(30) For a CompanyName field, orders for
companies whose name is more than 30 characters long

 

[Guest]

I'm sorry, I'll try to be more clear, I have a form in which I enter a
technician's name and the query returns the matches, at this point I have to
type the tech's name exactly how it appears in the field or it will not
return anything. I want to be able to type what I know is accurate and have
it return everything in the field that starts with what I typed in the form.
for instance I have a tech named acostas tomas, but say I don't know how to
spell acostas, I know it starts with "cos" I want to be able to type "acos"
and have it return all the records pertaining to acostas tomas. there are
270 techs and many users of my database. I want it to be as user friendly as
I can make it. thanks again

None of that is relavent to the criteria I need, as far as I can tell. I
appreciate it though.

You enter car and what you do want returned? Do you want ONLY those
that contain "car" only those that start with "car" only those that have
"car as a separate text?

I pasted the general instructions as that would answer most questions
and I am not sure of what your question really is. I guess Access does not
know either.

You may want to search on "criteria" in the Access help file. There is
additional help there.

Thanks
nick

From the Access help file.

Expression Result
"London" For a ShipCity field, orders shipped to London
"London" Or "Hedge End" For a ShipCity field, orders shipped to
London or Hedge End
="N" For a CompanyName field, orders shipped to companies whose
name
starts with the letters N through Z
Like "S*" For a ShipName field, orders shipped to customers whose
name starts with the letter S (ANSI-89)
Like "S%" For a ShipName field, orders shipped to customers whose
name starts with the letter S (ANSI-92)
Right([OrderID], 2) = "99" For an OrderID field, orders with ID
values ending in 99
Len([CompanyName]) > Val(30) For a CompanyName field, orders for
companies whose name is more than 30 characters long

 

[Joseph Meehan]

I'm sorry, I'll try to be more clear, I have a form in which I enter a
technician's name and the query returns the matches, at this point I have
to
type the tech's name exactly how it appears in the field or it will not
return anything. I want to be able to type what I know is accurate and
have
it return everything in the field that starts with what I typed in the
form.
for instance I have a tech named acostas tomas, but say I don't know how
to
spell acostas, I know it starts with "cos" I want to be able to type
"acos"
and have it return all the records pertaining to acostas tomas. there are
270 techs and many users of my database. I want it to be as user friendly
as
I can make it. thanks again

:

OK . Try "acos*" That works in my version.

You may also want to set up a drop down list where you can get close and
then choose from a list.

I assume the " I know it starts with "cos" " was a typo.

None of that is relavent to the criteria I need, as far as I can tell.
I
appreciate it though.
:

cherrynich wrote:
I made a query a while back that allowed me to return all the values
that
started with the letters I entered on a form I used to query. Does
anyone
have any idea how I might do this. for example I enter "car" and it
returns
carter and carpenter and caravelli. I know I need something in the
criteria
of the query I just dont know what it is.

You enter car and what you do want returned? Do you want ONLY those
that contain "car" only those that start with "car" only those that have
"car as a separate text?

I pasted the general instructions as that would answer most questions
and I am not sure of what your question really is. I guess Access does
not
know either.

You may want to search on "criteria" in the Access help file. There
is additional help there.

Thanks
nick

From the Access help file.

Expression Result
"London" For a ShipCity field, orders shipped to London
"London" Or "Hedge End" For a ShipCity field, orders shipped to
London or Hedge End
="N" For a CompanyName field, orders shipped to companies whose
name
starts with the letters N through Z
Like "S*" For a ShipName field, orders shipped to customers whose
name starts with the letter S (ANSI-89)
Like "S%" For a ShipName field, orders shipped to customers whose
name starts with the letter S (ANSI-92)
Right([OrderID], 2) = "99" For an OrderID field, orders with ID
values ending in 99
Len([CompanyName]) > Val(30) For a CompanyName field, orders for
companies whose name is more than 30 characters long

 

[John Smith]

I made a query a while back that allowed me to return all the values that
started with the letters I entered on a form I used to query. Does anyone
have any idea how I might do this. for example I enter "car" and it
returns
carter and carpenter and caravelli. I know I need something in the
criteria
of the query I just dont know what it is.

Thanks
nick

From the Access help file.

Expression Result
"London" For a ShipCity field, orders shipped to London
"London" Or "Hedge End" For a ShipCity field, orders shipped to London
or Hedge End

="N" For a CompanyName field, orders shipped to companies whose

name
starts with the letters N through Z
Like "S*" For a ShipName field, orders shipped to customers whose name
starts with the letter S (ANSI-89)
Like "S%" For a ShipName field, orders shipped to customers whose name
starts with the letter S (ANSI-92)
Right([OrderID], 2) = "99" For an OrderID field, orders with ID values
ending in 99
Len([CompanyName]) > Val(30) For a CompanyName field, orders for
companies whose name is more than 30 characters long