Results 1 to 2 of 2
  1. #1
    sknechte is offline Novice
    Windows 10 Access 2016
    Join Date
    Jan 2018
    Posts
    14

    Does anyone know how to display the customers' total sales in design view?

    Is there some way to add up the Total Spent value for each customer so there's no duplicates?


    Click image for larger version. 

Name:	Capture.jpg 
Views:	11 
Size:	192.2 KB 
ID:	32711

  2. #2
    John_G is offline VIP
    Windows 10 Access 2016
    Join Date
    Oct 2011
    Location
    Ottawa, ON (area)
    Posts
    2,615
    You can use a summation (totals) query to do this. You would "group by" on all the fields except TotalSpent, for which you would use "Sum".

    But what do you mean by "in design view" - in design view of what? Regardless, the answer to your question is No, you can't get a total in design view.

    You also need to rethink your data structure - it is not properly normalized. Was it imported from Excel?

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

Similar Threads

  1. Replies: 16
    Last Post: 12-28-2017, 02:04 PM
  2. total sales showing on a form
    By Jen0dorf in forum Access
    Replies: 3
    Last Post: 12-01-2015, 04:20 PM
  3. Replies: 3
    Last Post: 12-16-2013, 01:43 PM
  4. Replies: 2
    Last Post: 02-15-2012, 04:04 PM
  5. computing total sales per day using query
    By joms222 in forum Queries
    Replies: 0
    Last Post: 03-09-2009, 10:58 PM

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