I want to merge two queries into one ( see attachment ).
I've unioned queries before but only when one field has matched. This problem needs to match 2 fields.
Basically I want all the fields in NEWQRY_SUMRATES but only the fields Resource Whole and Availability from NEWQRY_DAYSBOOKED where Yr and Wk in NEWQRY_DAYSBOOKED match Yr and Wk in NEWQRY_SUMRATES.
Rich.
I've unioned queries before but only when one field has matched. This problem needs to match 2 fields.
Basically I want all the fields in NEWQRY_SUMRATES but only the fields Resource Whole and Availability from NEWQRY_DAYSBOOKED where Yr and Wk in NEWQRY_DAYSBOOKED match Yr and Wk in NEWQRY_SUMRATES.
Rich.