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!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Range in one query to determine which row in another query matches.

Status
Not open for further replies.
nickrugado

nickrugado

MIS
Dec 5, 2005
40
US
I have two queries one that pulls a record in the current year with an EffDate of 5/1/12 and the other query for the previous year that has multiple rows.

I want to find which of those 6 records was the one that was active 1 year ago using the EffDate from the current year query.

Anyone have any ideas, I have one that will require a lot of other work, I'm hoping this can be accomplished in a query.

I should also mention that what's pictured below is only 1 Key, where there will be a list of approx 100 individual records in the Current Year and Multiples in the Previous.

Thanks,
Nick
 
Status
Not open for further replies.

Similar threads

combo
  • Locked
  • Question
'Wrong property setting' message in query 1
Replies
2
Views
652
combo
combo
TheresAlwaysAWay
  • Locked
  • Question
Union query provides different reslt than when summing the combined queries individually 1
Replies
12
Views
453
TheresAlwaysAWay
TheresAlwaysAWay
TrekBiker
  • Locked
  • Question
Records in one table not in another 1
Replies
3
Views
162
Andrzejek
Andrzejek
JimStrand
  • Locked
  • Question
Crosstab query - returning 1 record per week instead of 1 record
Replies
1
Views
318
JimStrand
JimStrand
lameid
  • Locked
  • Question
SELECT FROM Table in Another Access File
Replies
2
Views
654
lameid
lameid

Part and Inventory Search

Sponsor

Back
Top