HI - I have two queries:
Query 1 - Has employee number and effective date
Query 2 - Has Begin and End Dates and Job Position
What Access function can I build to bring the Job Position together with the "effective date" in Query 1?
An example spreadsheet is attached.. Thanks.