Web Development

Ask something
Discussion Locked

Find or Search in a query!

0 helpful
3 replies

by whatme? 2 views

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Maybe this the wrong area but here goes. I have SQL2000 and database. I need to write a query(or something) (again, I am new at this), to type in approx 50 names(last,first),run it and "find" if they are in database X, and return the results, Not found section , found section. In the found section, I can insert more select statements to bring up all the data I can find on each of the found persons. I will be doing this process once a week.

3 replies

by john_wills

Use a recordset to search for the input name, copnstructing the Select with the input name. If you find that the recordset is empty you know that the name was not found in the table. Have two list tables on your form and construct for each a select statement as record source; augment the appropriate record source as you find or do not find a name.

by whatme?

sorry to take so long answering. I had to figure out how to do it. Done.. kind of. At least I am on the right track.
Thanks

This discussion is closed to new replies.