Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2005
    Posts
    1

    Probably a simple report question

    I have a table that contains a value that is unique to a given set of records. for example:

    1 ABC 123


    2 ABC 234
    3 ABC 345
    4 DEF 123
    5 DEF 234
    6 GHI 789

    and so on

    I want to write a report that writes out :

    ABC

    123
    234
    345

    DEF

    123
    234

    GHI

    789

    No matter what I do, I get a report that lists every line in the table per each value (ABC, DEF, GHI)

    Please Help!!

  2. #2
    StepUP is offline Advanced Beginner
    Windows 7 64bit Access 2000
    Join Date
    Dec 2005
    Posts
    99
    Just use the Sorting and Grouping capability in the report to Group By whatever the field name is for the "ABC" column of data.

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

Similar Threads

  1. Extremely simple ACCESS DB
    By austin3i62 in forum Access
    Replies: 1
    Last Post: 02-07-2008, 11:51 AM
  2. Simple but hard question
    By andymok in forum Reports
    Replies: 1
    Last Post: 09-20-2007, 09:19 AM
  3. Another email report question ...
    By valkyry in forum Reports
    Replies: 0
    Last Post: 05-23-2007, 11:42 PM
  4. Question on a report
    By Xena11 in forum Reports
    Replies: 2
    Last Post: 11-17-2006, 12:08 PM
  5. Should be simple Query Question
    By brj1 in forum Queries
    Replies: 2
    Last Post: 03-04-2006, 01:11 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
  •  
Other Forums: Microsoft Office Forums