Append query not working

[seth.murphine]

I have query 1 with the following sql:

SELECT yp_adv_data.ID, yp_adv_data.adQCC, yp_adv_data.adSalesD, Count(yp_adv_data.adQCC) AS CountOfadQCC
FROM yp_adv_data
GROUP BY yp_adv_data.ID, yp_adv_data.adQCC, yp_adv_data.adSalesD
HAVING (((yp_adv_data.adQCC)=False) AND ((yp_adv_data.adSalesD) Is Not Null));

Then query 2 with the following sql:

SELECT yp_adv_data.ID, yp_adv_data.adQCDate, Count(yp_adv_data.adQCC) AS CountOfadQCC
FROM yp_adv_data
GROUP BY yp_adv_data.ID, yp_adv_data.adQCDate
HAVING (((yp_adv_data.adQCDate) Between Date() And Date()-6) AND ((Count(yp_adv_data.adQCC))=True));

With an append query pulling the information from both queries to another table:

INSERT INTO yp_qc ( qc_comp, qc_open )
SELECT Sum(qc_comp.CountOfadQCC) AS SumOfCountOfadQCC, Sum(qc_open.CountOfadQCC) AS SumOfCountOfadQCC1
FROM qc_comp, qc_open;

If there is an easier way I am all ears, but as of right now I am getting a new record in yp_qc. The fields are blank though, it is not pulling any data.

[June7]

All looks reasonable. Do you want to provide project for analysis? Follow instructions at bottom of my post.

[seth.murphine]

Sorry about that, ok I think since the last time you saw this thing... it has grown some type of life because I feel like there is a lot going on in it.

Any other advice outside of this query question will not fall on def ears, but again thanks for looking at it.

The append query should be under "QC Open/Complete Report"

Impact1.zip

[June7]

I can't extract the file - get 'unknown compression format' error. I can open only Windows Compression zip file.

BTW, changed thread name to something more meaningful.

[seth.murphine]

Here you go

http://www.mediafire.com/?pq1c6wckrausj5d

[June7]

That was a learning experience.

Couldn't get multiple SELECT to work but DSum does:

INSERT INTO yp_qc ( qc_open, qc_comp ) Values(DSum("CountOfadQCC","qc_open"), DSum("CountOfAdQCC","qc_comp"));

Think your qc_comp query might need some edits:
SELECT yp_adv_data.ID, yp_adv_data.adQCDate, Count(yp_adv_data.adQCC) AS CountOfadQCC, yp_adv_data.adQCC
FROM yp_adv_data
GROUP BY yp_adv_data.ID, yp_adv_data.adQCDate, yp_adv_data.adQCC
HAVING (((yp_adv_data.adQCC)=True));