I've a (probably) silly question re Access 2013 queries. I've not done Access in years and even then only at a very low level.
I've got a query that returns a Date, a Client, A Unit and a Price. Some units have many clients in; some clients are in more than one unit.
13/4/15 Client1 Unit01 £3000
13/4/15 Client 2 Unit01 £2500
13/4/15 Client1 Unit02 £1800
13/4/15 Client2 Unit02 £600
I'm trying to display the query with just the total price per unit against each as below
13/4/15 Unit01 £5500
13/4/15 Unit02 £2400
What do I need to do to the query to make it show in this format? Or do I need another intermediate query to get that information out?