Results 1 to 2 of 2
  1. #1
    nick404's Avatar
    nick404 is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    May 2015
    Location
    Wisconsin
    Posts
    352

    Totaling Entries by Shift Query Between Two Dates

    I am making a query that will total the number of entries made by each shift (A, B, C, D) over a certain period of time.
    MY current SQL statement is giving me errors about syntax and/or missing operators.


    Code:
    SELECT Count(Entries.Shift) AS CountOfShift, Entries.Shift
    FROM Entries
    GROUP BY Entries.Shift
    WHERE ((Entries.EntryDate) = (Between [Enter Start Date] And [Enter End Date]))
    ORDER BY Count(Entries.Shift) DESC;
    The count works fine, i tested it alone, but I need the date parameter and that is causing the issues.

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    Drop the = sign.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Query/Report Record Grouping/Totaling
    By mikej2505 in forum Access
    Replies: 1
    Last Post: 10-04-2014, 10:29 AM
  2. Sub totaling in a query or report
    By n2mee in forum Queries
    Replies: 8
    Last Post: 11-16-2013, 03:55 PM
  3. Replies: 4
    Last Post: 04-23-2012, 05:07 PM
  4. Replies: 8
    Last Post: 03-30-2012, 06:05 AM
  5. Running totaling with a query
    By tttccc in forum Queries
    Replies: 1
    Last Post: 03-28-2012, 09:37 AM

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