Append query...how to?

[leddy]

Hi everyone,

In desperate need of help! )

I have two temp tables, temp_qryTotals and temp_qryTotalsOnService
temp_qryTotals:
sDate
TimeSlot
sCount
eCount

temp_qryTotalsOnService:
sDate
TimeSlot
osCount

What I need to do is if there is a record in temp_qryTotalsOnService, where the sDate and TimeSlot are not in temp_qryTotals, then I need to append the record to temp_qryTotals (osCount = sCount).

How can I achieve this please?

Any ideas, even to get me on track, would be great - I've been working on this for two days and am slowly losing the will to live!

Many thanks in advance

leddy

 

[Pat Hartman]

Start by using the wizard to create a find unmatched query. Then create an append query based on the unmatched query.

 

[khawar]

INSERT INTO temp_qryTotals ( SDate, TimeSlot, SCount )
SELECT temp_qryTotalsOnService.SDate, temp_qryTotalsOnService.TimeSlot, temp_qryTotalsOnService.OSCount
FROM temp_qryTotalsOnService LEFT JOIN temp_qryTotals ON (temp_qryTotalsOnService.TimeSlot = temp_qryTotals.TimeSlot) AND (temp_qryTotalsOnService.SDate = temp_qryTotals.SDate)
WHERE (((temp_qryTotals.SDate) Is Null));

 

[leddy]

Thank you both so much, got it sorted!

leddy