Results 1 to 2 of 2
  1. #1
    gbharris is offline Novice
    Windows XP Access 2007
    Join Date
    Aug 2011
    Location
    Denver, CO
    Posts
    1

    Crazy Counting


    I'm running a query that references on a specific equipment code. I'm trying to query to show when I get 5 of any one item code. Can anyone help?

    If this isn't possible, is there a way to configure a report to count the number of records displayed in a one up sequence and return only that count of record i'm looking for?

    Thanks in advance.

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    Difficult to answer without knowing the data structure. If you're counting transactions:

    SELECT ItemCode, Count(*) AS HowMany
    FROM TableName
    GROUP BY ItemCode
    HAVING Count(*) > 4
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Counting
    By rfs in forum Forms
    Replies: 0
    Last Post: 03-15-2011, 03:20 PM
  2. ShipToCode is driving me crazy
    By Accessgrasshopper in forum Access
    Replies: 7
    Last Post: 02-26-2011, 04:55 PM
  3. Report issue driving me crazy
    By Grofica in forum Reports
    Replies: 11
    Last Post: 01-28-2011, 11:23 AM
  4. Autonumber gone crazy
    By asearle in forum Access
    Replies: 1
    Last Post: 07-27-2010, 05:41 AM
  5. HELP with crazy receipt numbering
    By jlm722 in forum Forms
    Replies: 15
    Last Post: 09-23-2009, 01:49 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