Append query not appending

[dark11984]

I've got an append query that appends 1 column from 4 different tables into 1 table daily. It works fine up until 1 of the tables has no data in it, than it does not append any of them.

Is there a way to get around this?

Thanks

 

[Pat Hartman]

The general answer is to change your inner joins to left joins but you'd need to give us more information regarding the relationships to be sure that that is the correct answer.

 

[dark11984]

This is what my joins currently are:

INSERT INTO [Stats Table] ( [Date], Overcommitted, [Delivery Confirmations], PHistory, DCHistory )
SELECT [Count Del Confirmation for Stats].Date, [Count Overcommitted for Stats].Overcommited, [Count Del Confirmation for Stats].DelConfirm, [Count PHistory for Stats].PHistory, [Count DCHistory for Stats].DCHistory
FROM (([Count Del Confirmation for Stats] INNER JOIN [Count Overcommitted for Stats] ON [Count Del Confirmation for Stats].Date = [Count Overcommitted for Stats].Date) INNER JOIN [Count PHistory for Stats] ON [Count Overcommitted for Stats].Date = [Count PHistory for Stats].Date) INNER JOIN [Count DCHistory for Stats] ON [Count PHistory for Stats].Date = [Count DCHistory for Stats].Date;

 

[Pat Hartman]

Did you try changing the inner joins to left joins?