Union Query not linking

[Corey]

Hi All,

Could someone please look at the attached database and help me understand why my Union Query is not matching up correctly with the Program ID?

See attached

Thank you for all your help

 

[Matt Greatorex]

1) You're grouping by 'program id' and not mentioning any other fields as group or sum. You need to remove all grouping or ensure all fields are included in some way.
2) The 'Sent' field has a different name in query B1.
3) 'Clicks' field has a different name in query B1.
4) 'Sent' field has a different name in query B1.

I think that fixes it.