Search results

Some fields in my report are duplicate, so when I try to calculate the grand total, it sum all fields. Is there a way I can sum just distinct value.

Please help me as I am new at MS Access so I dont know if I can do this and if can, how do I do it ? I have two table: Orders and Category Orders: Ord # Descript Amount 1 Cake 10 2 Toner 30 3 Books 30 4 Tonners 10 Category: Cat Text Tonner like "*toner*" or like "*tonner*"...