Query Help

[CJ]

I have a query set up where when it runs it prompts me for
a persons name and then it will find every record with
that persons name. However, I have to type in the full
name as that person entered it into the system so if I
wanted to look for a specific person I would have to know
if they entered it like "Doe, Jane" or "Jane Doe" or "J.
Doe" and then it would have to be entered exactly like
that for the query to find it. Is there anyway, when
prompted, that I can just type "Doe" and it will find
everybody with that name??? THanks!

CJ

 

[Arvin Meyer]

I have a query set up where when it runs it prompts me for
a persons name and then it will find every record with
that persons name. However, I have to type in the full
name as that person entered it into the system so if I
wanted to look for a specific person I would have to know
if they entered it like "Doe, Jane" or "Jane Doe" or "J.
Doe" and then it would have to be entered exactly like
that for the query to find it. Is there anyway, when
prompted, that I can just type "Doe" and it will find
everybody with that name??? THanks!

If your fields are properly configured, you will have the LastName field
separated so that it is in it's own field. Use syntax like:

[Enter any name] & * you will find any name which begins with the characters
enter. For an example of a partial name search look at the search form code
on my website:

http://www.datastrat.com/Download/Search2K.zip
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[CJ]

-----Original Message-----

I have a query set up where when it runs it prompts me for
a persons name and then it will find every record with
that persons name. However, I have to type in the full
name as that person entered it into the system so if I
wanted to look for a specific person I would have to know
if they entered it like "Doe, Jane" or "Jane Doe" or "J.
Doe" and then it would have to be entered exactly like
that for the query to find it. Is there anyway, when
prompted, that I can just type "Doe" and it will find
everybody with that name??? THanks!

If your fields are properly configured, you will have the LastName field
separated so that it is in it's own field. Use syntax like:

[Enter any name] & * you will find any name which begins with the characters
enter. For an example of a partial name search look at the search form code
on my website:

That didn't work. Why does the last name have to be
separated from the rest of the name? Acess can't seem to
find the word Jane in the word Jane Doe. If I type in Jane
Doe it works but not if I do anything plus *

 

[HSalim]

Use Like "Jane*"

-----Original Message-----

I have a query set up where when it runs it prompts me for
a persons name and then it will find every record with
that persons name. However, I have to type in the full
name as that person entered it into the system so if I
wanted to look for a specific person I would have to know
if they entered it like "Doe, Jane" or "Jane Doe" or "J.
Doe" and then it would have to be entered exactly like
that for the query to find it. Is there anyway, when
prompted, that I can just type "Doe" and it will find
everybody with that name??? THanks!

If your fields are properly configured, you will have the LastName field
separated so that it is in it's own field. Use syntax like:

[Enter any name] & * you will find any name which begins with the characters
enter. For an example of a partial name search look at the search form code
on my website:

That didn't work. Why does the last name have to be
separated from the rest of the name? Acess can't seem to
find the word Jane in the word Jane Doe. If I type in Jane
Doe it works but not if I do anything plus *