Results 1 to 2 of 2
  1. #1
    cbx is offline Novice
    Windows 10 Office 365
    Join Date
    Feb 2024
    Posts
    1

    Calculations between queries

    I have 2 queries: one with a count of shifts worked, and the other with a total of hours worked. I'm trying to generate a query that contains both query fields ([shifts] and [hours]) and does the math to determine the hours worked per shift. Basically, I'm looking to calculate [shifts] / [hours] in a separate field, but I haven't been able to get it to work. I'm fairly new to query design. Can anyone help?

    Thank you

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,430
    Maybe - if you provide:
    - details of the queries and the underlying tables
    - plus some example data and the outcome required from that example data

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

Similar Threads

  1. Replies: 6
    Last Post: 08-02-2016, 01:40 PM
  2. Query calculations off other queries
    By CT_AccessHelp in forum Queries
    Replies: 3
    Last Post: 03-14-2016, 10:14 AM
  3. Help with doing calculations in queries
    By DB88 in forum Access
    Replies: 3
    Last Post: 05-14-2014, 04:39 PM
  4. using calculations in queries
    By EWIG in forum Queries
    Replies: 3
    Last Post: 01-29-2014, 11:55 AM
  5. Replies: 1
    Last Post: 10-08-2012, 03:35 PM

Tags for this 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
  •  
Other Forums: Microsoft Office Forums