Append Query

[Parra]

I have the following append query, but it does not capture all the records.

SELECT [1st date],[account #],[account name],[dollars]
from [revenue]

UNION select [1st date],[account #],[account name],[dollars]
from [revenue 2002];

Does anyone have any ideas why it doesn't or of any changes.

Thanks

 

[dk]

I have the following append query, but it does not capture all the records.

SELECT [1st date],[account #],[account name],[dollars]
from [revenue]

UNION select [1st date],[account #],[account name],[dollars]
from [revenue 2002];

Does anyone have any ideas why it doesn't or of any changes.

Thanks

Hi,

By default, a union query will return distinct records only. Just put the word ALL after the word UNION.

 

[Parra]

That was simple, I was confused all day.

Thanks I tried it and it worked.