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 Chriss Miller 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
Joined
Dec 5, 2005
Messages
40
Location
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

C
  • Locked
  • Question Question
Query expression negative to a 0
Replies
6
Views
728
dhookom
dhookom
mhshane
  • Question Question
Is this the best way to do this query?
Replies
9
Views
575
mhshane
mhshane
TheresAlwaysAWay
  • Question Question
Why does what appears to be a simple append query is pasting 5 duplicate rows?
Replies
9
Views
224
TheresAlwaysAWay
TheresAlwaysAWay
C
  • Locked
  • Question Question
Run-time error '3075': Syntax error (missing operator) in query expression 'Birthday = and Birthmonth ='.
Replies
3
Views
592
OzFoxy
OzFoxy
serino
  • Locked
  • Question Question
Help with a Query.
Replies
13
Views
1K
strongm
strongm

Part and Inventory Search

Sponsor

Back
Top