Results 1 to 2 of 2
  1. 03-12-2013, 11:10 AM #1
    thegnome
    thegnome is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2013
    Posts
    1

    Report Based on Field Frequency

    Hi, I don't think my question should be too difficult, but I didn't have any luck searching.

    I have a field with a drop down list. I want my report to show what the top 10 of those were for records in the past week.



    Thanks
    Reply With Quote Reply With Quote
  2. 03-12-2013, 12:28 PM #2
    June7's Avatar
    June7
    June7 is online now VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    Review
    http://support.microsoft.com/kb/210039
    http://allenbrowne.com/subquery-01.html
    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. Report field: Pull data from different table based on value in different field
    By fsask2013 in forum Reports
    Replies: 2
    Last Post: 03-07-2013, 04:50 PM
  2. Hide field in sub-report based on condition
    By vinsavant in forum Reports
    Replies: 4
    Last Post: 12-16-2012, 10:18 AM
  3. Report based on particular field
    By Sorbz62 in forum Reports
    Replies: 24
    Last Post: 02-25-2012, 04:40 PM
  4. Colors of Report change based on field/criteria
    By yes sir in forum Reports
    Replies: 30
    Last Post: 03-01-2011, 10:05 AM
  5. Generate reports by frequency
    By MFS in forum Programming
    Replies: 2
    Last Post: 11-18-2010, 08:09 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums