Report using a filter

[chris89]

Hello ,
I have a table that seems like the attached pic
Now what I really want is to have a sum by : product , month , year
The problem is that I have more than 2 products (about 60) so I can t do it by hand everytime.
Is there a way to achieve this in Access 2007
p.s. I m very new to access and sql so any help would be much appreciated

Thank you in advance

 

[vbaInet]

Welcome to the forum chris89.

Have a look at these links:

http://office.microsoft.com/en-us/access-help/summing-in-reports-HA001122444.aspx
http://www.databasedev.co.uk/access2007_summing.html

 

[chris89]

Thank you for your reply I'll check it out!

 

[chris89]

I looked into those links and I figured out how to do it in a report!
Is there another way to do it on a query?
Here is what I really would like to have :
query that has the following fields: product ,month , year total that is calculated per Month for each product and total that is calculated per year.(attachement shows it better I think!)
Any help would be much appreciated
Thank you again!

 

[vbaInet]

Yes it's possible. Search the microsoft office site I gave you for Sum data in a query.

You will need to use the Format() function to get the month name, or alternatively use the Month() and MonthName() functions. For year, use the Year() function.

Look at this site for the functions mentioned above:

http://www.techonthenet.com/access/functions/index.php

 

[chris89]

And for products grouping should I use DISTICT function ?

Thank you for your reply

 

[chris89]

Ok I am really close now thank you very much!

 

[vbaInet]

Summing would already result in distinct results.