Hi there,
I apologize in advance as I am fairly new to access. I am in the process of reading a few books but help from the forum on this issue would help speed things along.
I have 3 tables
1) Mapping table that links ID's to Brand Name
2) Table for Product A sales by brand by month
ID
Brand
Sales
Month
3) Table for Product B sales by brand and by month
ID
Brand
Sales #
Month
What I am trying to do is sum the sales by Brand each month. Problem is some brands have only Product A and not B (vice versa).
Currently, my query only displays values where Both A & B have sales in a simliar month. I tried using the Nz to preface the query but it is not the query that is the issue as when I simply add Table B to the design view my results of the query are limited by the values in table B.
I hope I am explaining this well enough. Thanks for your help
I apologize in advance as I am fairly new to access. I am in the process of reading a few books but help from the forum on this issue would help speed things along.
I have 3 tables
1) Mapping table that links ID's to Brand Name
2) Table for Product A sales by brand by month
ID
Brand
Sales
Month
3) Table for Product B sales by brand and by month
ID
Brand
Sales #
Month
What I am trying to do is sum the sales by Brand each month. Problem is some brands have only Product A and not B (vice versa).
Currently, my query only displays values where Both A & B have sales in a simliar month. I tried using the Nz to preface the query but it is not the query that is the issue as when I simply add Table B to the design view my results of the query are limited by the values in table B.
I hope I am explaining this well enough. Thanks for your help