Pulling field based on 2 fields of other table

[Guest]

Hi,

My appologies for the basic question.
I am in middle of creating a query on two tables. Both have STATE field so
I just created a relationship. First table has Eff Date, the second table
has StartDate and EndDate. I want to pull SALARYGROUP which is on the
second table to the first table matching on state and also so that Eff Date
was between StartDate and EndDate.
Hope I am being clear.

Thank you for you help!
______
Regards,
Greg

 

[gls858]

Hi,

My appologies for the basic question.
I am in middle of creating a query on two tables. Both have STATE field so
I just created a relationship. First table has Eff Date, the second table
has StartDate and EndDate. I want to pull SALARYGROUP which is on the
second table to the first table matching on state and also so that Eff Date
was between StartDate and EndDate.
Hope I am being clear.

Thank you for you help!
______
Regards,
Greg

You just need to build a query using the two tables, then
add the fields you want.

Under objects click on query > New > Design View and add the
two tables. Drag the field you want onto the grid below.

gls858

 

[Guest]

What do I do afterwards?
I would only need to retain the records where Table1.State = Table2.State
and where EffDate.Table1 is between StartDate.Table2 and EndDate.Table2

Thanks again.