Sure. Once you have the data the way you want in your aggregate query, just use form footer totals.

Hello Richard the answer is yes I have done less than on level 22 to fix the problem of changing products pricing so if I am understanding correctly it is safe if I even scrapped the old product table and re-crated it please confirm before you shutdown for Christmas thank you and Merry Christmas once again

Michelle

If you fixed your database so that changes to the product table do not effect the order details table, then you should be OK. The only way to be SURE is to just make a change and check it.

Hello Richard

Thank you for all your help I've doublechecked the order detail table after changing a price in the product table and yes everything is working properly it is not affecting previous orders Merry Christmas don't know when you will be around to message again as I'm sure you will be taking Christmas off enjoyed joining as the member for those extended cuts so please make sure as you said in one of your videos some people have not got the extras added onto their account yet so please check Merry Christmas I'll think of you my Boxing Day enjoying your Christmas Day, and I see you have the New Zealand flag flying on my messages

Michelle

Glad everything is working well for you. I'll be around over the holidays. I'm not really taking any time off. I work from home, so I'll probably be working just as much as usual. Not visiting family or anything. Just a quiet time here with me, the girlfriend, and the puppy. Unlike you guys over there in NZ, we've still got the Covid running around because our leaders have their heads up their asses. (No, this isn't political. ALL of our leaders are idiots). But Merry Christmas to you. Hope all is well!