Help With Microsoft Access
Results 1 to 4 of 4

Thread: Help With Microsoft Access

  1. #1
    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>

  2. #2
    Join Date
    Oct 2006
    Location
    Maitland NSW Australia
    Posts
    274
    No. You need two queries one to give you the total the other to give you the result.
    Allan

  3. #3
    Join Date
    Nov 2013
    Posts
    5
    Thanks for you answer Allan. I will keep this in my mind.

  4. #4
    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. **

Posting Permissions

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