Search results

Hello I have two tables that have the following fields: tableProd: tableProd.Prod, tableProd.valueProd, tableProd.dateProd and tableRec: tableRec.Prod, tableRec.Ing, tableRec.valueRec I want to create a query where it finds where tableProd.Prod is equal with tableRec.Prod and then multiply...

Ok thank you a lot

So if i understand this right I can't have a A,B,C field and at Totals row where sumA, sumB appears at column C were an expression like :(sumA-sumB/sumA)*100 . is that correct?

I mean if you can do that what s the point if access can't do anything with it?

What do you mean by that?And how can I do it ? Thank you a lot btw for your patience

(I know this might be a silly question...) Is there a way on writing a custom function on the totals row in Access 2007? I mean there is a dropdown with sum , max,min , etc .Can I write something my own?

Ok I am really close now thank you very much!

And for products grouping should I use DISTICT function ? Thank you for your reply

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...

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

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...