Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How can i search two or third feilds in the same table with a querry
- Thread starter dmhayes
- Start date
You can use a union query to combine the two fields into one. Then, in a second select query, join on the merged fields and search it.
Union queries have to be written in SQL...you can't use the query builder for it. Lookup help on SQL specific queries in Access Help...it should be able to walk you through it.
-Patrick
Nine times out of ten, the simplest solution is the best one.
Union queries have to be written in SQL...you can't use the query builder for it. Lookup help on SQL specific queries in Access Help...it should be able to walk you through it.
-Patrick
Nine times out of ten, the simplest solution is the best one.
- Status
Similar threads
- Locked
- Question
