Thanks for the quick answer.
Actually I've managed to make the sum directly on my report which works. The only problem I have left is that when the second value is null, it writes error which is logical since 1+null= error.
So I need to figure a way to make my query give 0 to all null. Here...
Hey everyone,
Alright so here is what I have :
Table : Order
Customer___________Item 1_______ Item 2
Johnny_______________ steak__________ fries
Jimmy _______________hamburger
Arnold________________ rice___________ steak
I need to be able to count the number of record for each item. Any...