Results 1 to 5 of 5
  1. #1
    nzlotrfan is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2013
    Posts
    4

    Need help with a few queries

    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

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    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.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    nzlotrfan is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2013
    Posts
    4
    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.
    Last edited by nzlotrfan; 05-15-2013 at 12:07 AM. Reason: spelling

  4. #4
    nzlotrfan is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2013
    Posts
    4

    One more query!

    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

  5. #5
    nzlotrfan is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2013
    Posts
    4
    Don't worry re post #4, got it sorted now.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Two queries in one
    By SPW_12 in forum Access
    Replies: 5
    Last Post: 09-01-2012, 07:35 PM
  2. Using Sub Queries?
    By djclntn in forum Queries
    Replies: 4
    Last Post: 04-05-2012, 08:58 AM
  3. Bit of a odd Queries
    By winterh in forum Queries
    Replies: 2
    Last Post: 03-14-2012, 03:03 PM
  4. Need Help with Queries
    By mulefeathers in forum Queries
    Replies: 2
    Last Post: 05-24-2010, 11:37 AM
  5. need help with queries
    By gromit95 in forum Queries
    Replies: 1
    Last Post: 02-06-2009, 06:50 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums