Results 1 to 2 of 2
  1. #1
    shinydiamond is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Mar 2016
    Posts
    31

    Summations in Access 2016 Web App queries

    Hi All,


    First, please let me preface my question so that it's clear that I'm referring to the Access Web App, NOT the desktop version of Access. What works easily in the desktop version is usually quite cumbersome in the web app.

    I have a multi-user Access Web app database that I have up and running for a sales team. The problem I'm running into is creating some simple queries so they can see their potential sales by product and quarter. I need the query to display about 10 fields and then do a simple summation of $ for the product totals. For the life of me, I can't figure out how to achieve this simple task. If I create a Summary View, I'm limited to only showing 4 fields which is practically useless since two of my fields are needed for security so that each person can only see their own orders.

    Has anyone figured out a way to get totals for a multi-field query to work?

  2. #2
    shinydiamond is offline Advanced Beginner
    Windows 7 64bit Access 2016
    Join Date
    Mar 2016
    Posts
    31
    I'm still looking for help on this issue if any one is a web app user and has solved this...?

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

Similar Threads

  1. Replies: 1
    Last Post: 02-23-2016, 11:14 AM
  2. Access 2016
    By Gina Maylone in forum Access
    Replies: 3
    Last Post: 12-11-2015, 09:44 PM
  3. Replies: 1
    Last Post: 12-07-2015, 10:06 AM
  4. What's new in Access 2016
    By pbaldy in forum Access
    Replies: 6
    Last Post: 09-28-2015, 12:41 PM
  5. Creating Compound summations etc.
    By ohthesilhouettes in forum Queries
    Replies: 2
    Last Post: 06-19-2011, 12:29 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