Results 1 to 4 of 4

Thread: Help With Microsoft Access

  1. 09-04-2012, 09:35 PM #1
    kasy
    kasy is offline Registered User
    Join Date
    Sep 2012
    Posts
    1

    Help With Microsoft Access

    Hi,

    I have a query that groups data and produces two totals for each
    group. A second query takes this first query as its input and
    divides one total by the other for each group. Is it possible to do
    this in one step?

    Kasy
    <a href='http://corbincreative.com/'>Microsoft Access</a>
    Reply With Quote Reply With Quote
  2. 09-10-2012, 07:54 AM #2
    Allan Murphy
    Allan Murphy is offline Registered User
    Join Date
    Oct 2006
    Location
    Maitland NSW Australia
    Posts
    275
    No. You need two queries one to give you the total the other to give you the result.
    Allan
    Reply With Quote Reply With Quote
  3. 11-29-2013, 10:02 AM #3
    filo
    filo is offline Registered User
    Join Date
    Nov 2013
    Posts
    5
    Thanks for you answer Allan. I will keep this in my mind.
    Reply With Quote Reply With Quote
  4. 11-14-2017, 07:41 AM #4
    database007
    database007 is offline Registered User
    Join Date
    Nov 2017
    Posts
    1
    You can do with third query.
    I am also a database designer. I am an Oracle Certified Professional (OCP).
    For more information visit my profile

    ** Link Removed by Site Staff. **
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules