Total Value of All products?

[tuestunim]

Hi,

I'm in an inquisitive mood today and am wondering how much it would come to if a customer was to order 1 of everything. Is there any kind of report I can run to find out? Either that or it's a lot of clicking and I don't know if I'm really that bothered about it!

Scott.

[NormanRouxel]

A rough way that sums the basic product price:

Open ActinicCatalog.mdb in Access, open the Product Table, locate and highlight the Price column, copy to clipboard, Paste into a column in Excel and sum that column, finally divide by 100 as the price is in pennies.

[tuestunim]

Thank you very much I'll wander off and do that now.

Really should have thought of that myself, I've used access and excel a lot in the past.

Cheers,

Scott.