Results 1 to 4 of 4
  1. 01-28-2014, 04:09 PM #1
    Vapoldo
    Vapoldo is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Jan 2014
    Posts
    2

    Using the Top Value field in a query.

    I have a query that contains multiple providers claim history. I am trying to identify the top ten occuring procedures for each provider. When I use the Top Values option, it provides the top ten proceedures for all providers not the top ten for each provider. Any suggestions?
    Reply With Quote Reply With Quote
  2. 01-28-2014, 04:38 PM #2
    June7's Avatar
    June7
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    Review http://allenbrowne.com/subquery-01.html#TopN
    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.
    Reply With Quote Reply With Quote
  3. 01-29-2014, 02:44 PM #3
    Vapoldo
    Vapoldo is offline Novice
    Windows 8 Access 2010 32bit
    Join Date
    Jan 2014
    Posts
    2
    It worked!!! Thanks soooo very much. I didn't realize I needed to work with two queries. I was trying to do everything in the one!
    Reply With Quote Reply With Quote
  4. 01-29-2014, 02:53 PM #4
    June7's Avatar
    June7
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    Nested subqueries add a lot of power to SQL. That link has several you might find of interest.
    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.
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Newbie question - populating a field from a count field on a query
    By Turncloud in forum Queries
    Replies: 4
    Last Post: 07-28-2013, 12:40 AM
  2. Update a form field by double clicking a query field
    By Xarkath in forum Access
    Replies: 6
    Last Post: 04-26-2013, 10:07 AM
  3. How to construct query to match field content in one table to field name in another
    By ekierce in forum Queries
    Replies: 5
    Last Post: 04-23-2013, 01:42 PM
  4. Convert Memo Field to Text Field in a Make Table Query
    By jo15765 in forum Queries
    Replies: 5
    Last Post: 06-19-2012, 10:46 AM
  5. Cannot Update a table from a Query field based on a sum and grouped field..
    By Will in forum Queries
    Replies: 1
    Last Post: 08-31-2011, 04:03 PM

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

Other Forums: Microsoft Office Forums