Total sales figure from within Actinic

[paulbeckett]

Hi

Can anyone suggest the best/easiest way to obtain the total number of sales within a given time period.

I am sure I should be able to etract this figure from an access query but I am not sure exactly how to do. It would presumably be using the orders table and displaying all orders between a certain date range - but can anyone recommend how I might obtain the single figure (total)?

Kind regards

Paul
www.kjbeckett.com

[Jan]

You can run the sale analysis report I think, specifying the dates for period you want.

I use my One Stop Order Processing program, if you right click on any column in the order display it gives you the total for that column, so it is great for amount of money made, amount of orders placed, quantities of a particular product sold, total quantities sold. This is something that it is really really good at.

Regards,