I'm needing to create four useful queries for a database project. I've just started on the first one I want to create which is 'Total billing per client', however I can't get it to work. I'm a bit of a novice with Access and databases you see.
The query has Client Name, Client Number, Invoice Number, Invoice Amount.
For Invoice Amount, I selected Total: SUM. But it doesn't do anything.
Is somebody able to have a look and see if you can it working? Thanks!Database5.zip