can you use a column for an entire query as a criteria?

I

icemonster

Registered User.
Local time
Today, 09:24
Joined
Jan 30, 2010
Messages
502
so am thinking, is it possible to use an entire column as a query's criteria? like WHERE fieldtobefiltered = thefieldtobeusedascriteria from query1
 
The most efficient method would be to join the two queries on the related fields.
 
You must log in or register to reply here.

Similar threads

R
Finding which queries use specific control from the main form
2
Replies
35
Views
1,803
Pat Hartman
P
G
Again, query where dealing with empty fields
Replies
13
Views
1,293
theDBguy
theDBguy
oxicottin
Solved DCount Date field for duplicates giving Error#
Replies
8
Views
732
Ken Sheridan
Ken Sheridan
C
Solved Is it possible to use (like) in a query for a field in another table
Replies
11
Views
886
DHookom
DHookom
H
Solved IsNull not working in query
2
Replies
21
Views
1,319
hrdpgajjar
H

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom