Need Help please...!!!

[Guest]

Hello every Body.

I am making a DB in Access. I have a Query for Search which takes Parameter
Name and search out the entire record in the table and display it.
For that I gave the criteria ...........LIKE [Enter the name to search:] &
"*".

I am ok and good with it. But my query is dispalying all the matching
Records in the table. So if the number of Dispalyed Rcords by the query is
more than 100 then its difficult to search my specific one amongst them .

So is there any technique for this to search any specific record in the
SEARCHED records again.If yes then please mention. I want to search again in
the displayed table.


Thanks,
Khaksar.

 

[Guest]

When you say "specific one" what do you mean?

 

[Guest]

From Specific one i mean that record for which I am searching. For Example.
If am searching for scubadiver and there are 100 Scubadiver then it will show
the 100 record. How i will know easily that this is the Scubadiver for what I
am searching. Lets us consider that after getting the search result form the
query i want to search the table again through Phone number. Then what should
do.

Thanks,

When you say "specific one" what do you mean?

--

http://www.ready4mainstream.ny911truth.org/index.html

Hello every Body.

I am making a DB in Access. I have a Query for Search which takes Parameter
Name and search out the entire record in the table and display it.
For that I gave the criteria ...........LIKE [Enter the name to search:] &
"*".

I am ok and good with it. But my query is dispalying all the matching
Records in the table. So if the number of Dispalyed Rcords by the query is
more than 100 then its difficult to search my specific one amongst them .

So is there any technique for this to search any specific record in the
SEARCHED records again.If yes then please mention. I want to search again in
the displayed table.


Thanks,
Khaksar.

 

[Guest]

Why not include more parameters for each field or since you are searching
for a particular field there must be something (other than the ID) unique to
that record like phone number?


--

http://www.ready4mainstream.ny911truth.org/index.html

From Specific one i mean that record for which I am searching. For Example.
If am searching for scubadiver and there are 100 Scubadiver then it will show
the 100 record. How i will know easily that this is the Scubadiver for what I
am searching. Lets us consider that after getting the search result form the
query i want to search the table again through Phone number. Then what should
do.

Thanks,

When you say "specific one" what do you mean?

--

http://www.ready4mainstream.ny911truth.org/index.html

Hello every Body.

I am making a DB in Access. I have a Query for Search which takes Parameter
Name and search out the entire record in the table and display it.
For that I gave the criteria ...........LIKE [Enter the name to search:] &
"*".

I am ok and good with it. But my query is dispalying all the matching
Records in the table. So if the number of Dispalyed Rcords by the query is
more than 100 then its difficult to search my specific one amongst them .

So is there any technique for this to search any specific record in the
SEARCHED records again.If yes then please mention. I want to search again in
the displayed table.


Thanks,
Khaksar.