Search results

thanks for your reply

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.

I've tried some examples for search form, however it did not match what I require. thank you for your time. p.s: do you know any good website where I can find tutorial for Access 2003? I cant seem to find any that explain things in simple term and step by step.

Thanks for your reply, however as I am just a beginer at this, I've no idea how write SQL or coding stuff. I'll stick with the hardcode. :)

Thanks for your reply. I can hardcode the criteria, however I want to make it dynamic so users can later change the criteria and the search will varied.

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