Need help with a few queries

[nzlotrfan]

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

[June7]

If you want aggregate calc by client then can't include the invoice number in the query. You have the invoice number in the query 3 times.

If you want to see detail info as well as the aggregate value, build a report with Grouping & Sorting features and aggregate calcs in group footer.

[nzlotrfan]

Whoa you're right -what an idiot (me). I've been staring at the screen for too long it would seem! Thanks for that, most helpful.

[nzlotrfan]

Just a question regarding one more query. I'm wanting to now create a query that displays the 'Total Hours Flown By Employees'. But I can't seem to get it working.


Would you (or someone else) be willing to take another look for me? I've included an updated Database file. Many thanks!

Database6.zip

[nzlotrfan]

Don't worry re post #4, got it sorted now.