Combine Sums of fields with same first column

[pbaldy]

The LEFT JOIN should be pulling up the stores. Is it not? You should be able to use the Nz() function to show a zero for the ones that don't have records.

[mjdizenzo]

No, ALL the stores aren't coming up, only those that have that specific merchant #. How do I execute the nz() function

[mjdizenzo]

Let me try to better explain. I have a query so that I can get all the information for merchant 66771 by Store #. However all the stores don't necessarily have merchant # 66771 attached to them. If they DON'T have merchant 66771 I still want the store # to show up, but show 0 values for the rest of the columns.

[pbaldy]

Can you post a sample db here to play with?

[mjdizenzo]

www.mrmet.net/test.rar

If you run the query and enter in "05/13/2012" for example you will see it returns only 690 records for merchant 66771 however I want ALL the stores to show up and if merchant 66771 doesn't exist for those stores just return 0s for the rest of the columns.

[mjdizenzo]

www.mrmet.net/test.rar

If you run the query and enter in "05/13/2012" for example you will see it returns only 690 records for merchant 66771 however I want ALL the stores to show up and if merchant 66771 doesn't exist for those stores just return 0s for the rest of the columns.

anyone able to figure this out?

[pbaldy]

I don't have software to unzip an rar file, and don't care to install it. I also don't like to go to unknown sites to download files, which is why I asked if you could post it here.

[mjdizenzo]

I don't have software to unzip an rar file, and don't care to install it. I also don't like to go to unknown sites to download files, which is why I asked if you could post it here.

It won't let me upload a .zip file and the .mdb is too large.

[mjdizenzo]

ok try this http://www.mrmet.net/access/ the file is called test.mdb and this is hosted on my website