Sales Report (1 Viewer)

Diamond-Leopard

Registered User.
Local time
Today, 23:42
Joined
Oct 30, 2018
Messages
26
I have a table and it contains all the sales I have ever made, it has information like sales_date, Order_Profit, Customer_Name etc...

I would like a button on a form which when pressed displays how many sales and how much profit I have made on each day...

So I would like it to look like this


Date - Sales - Profit

19/11/2018 - 16 Sales - £78.65
20/11/2018 - 21 Sales - £92.12
21/11/2018 - 4 Sales - £18.90

I am being deliberatly vague about how I want this done because I really don't know if this is best viewed in a Report, or a Query or a Form or even a Table lol

I have a form which I use to process orders and that form populates my Order Table but I would just like an easy way to view my daily income?
 

Diamond-Leopard

Registered User.
Local time
Today, 23:42
Joined
Oct 30, 2018
Messages
26
Thank you very much, I am reading that link now :D
 

Diamond-Leopard

Registered User.
Local time
Today, 23:42
Joined
Oct 30, 2018
Messages
26
That's great thank you, So I now have a totals query and it tells me the profit I have made each day... what I would like now is to do some maths with the results... A simple example is if each day to run it costs me £40.

My Current Query Does this

Date - Sales - Profit

19/11/2018 - 16 Sales - £78.65
20/11/2018 - 21 Sales - £92.12
21/11/2018 - 4 Sales - £18.90

What I would like to do now is add a calculation at the end?

Date - Sales - Profit - Running Cost - Profit After Costs

19/11/2018 - 16 Sales - £78.65 - £40 - £38.65
20/11/2018 - 21 Sales - £92.12 - £40 - £52.12
21/11/2018 - 4 Sales - £18.90 - £40 - -£21.10

I know this is probably really simple too so any help would be apprieciated thanks
 

Minty

AWF VIP
Local time
Today, 23:42
Joined
Jul 26, 2013
Messages
10,355
The simple way - Make a new query with your existing totals query in it. Add a new calculated field

ProfitAfterCosts: [Profit] - 40

You can put this in the original totals query but it's not quite as simple.
 

Users who are viewing this thread

Top Bottom