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?
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?