Pulling field based on 2 fields of other table

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Greg said:
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
Click to expand...
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
 
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.
 
Back
Top