Results 1 to 5 of 5
  1. #1
    LonnieCAR is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2014
    Location
    Kansas City, MO
    Posts
    32

    Have report display all data for specific OrderID number.


    I am a novice at Access first off. I have a form with a subform, several queries, and some reports that I have created. I would like my reports to display a list of data for all orders of a specific PO Number, or Order ID number or File Number. If you look at my attachment they all have unique numbers and it doesn't matter which one since they are all linked together. My problem is, I can't seem to get all the data from a specific ID number to display in my report. I just want to generate a report for each order entered into the system. I am having a difficult time figuring out how to get a report to generate all of the data in my Add or Edit form and its Subform. I would also like to display Product ID information like its leg, length and thickness if possible. Any help here would be much appreciated. I have been searching the Internet for days now and even purchased an Access 2010 books for Dummies, but I am just getting no where. Thank you.
    Attached Files Attached Files

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    (without looking at your attachment)
    Your query (for the report) must have all the fields you want to display.
    Then in the report, did you set GROUPING?
    This will keep all of 1 order items / details together.

  3. #3
    LonnieCAR is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2014
    Location
    Kansas City, MO
    Posts
    32
    I did create a query for all the things I'd like to have in my report. I even created a report that looks halfway decent. However, it won't display everything I need. It will link some of the select things I need, but it keeps displaying random products for me. Not sure if I did set the grouping or not. Could you please give me some pointers on this? Thanks.

  4. #4
    LonnieCAR is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2014
    Location
    Kansas City, MO
    Posts
    32
    I created the query 'Orders Summary 2 Test' to display the information I need in my reports. I would like them to pull from each table and display the appropraite data for each order. However, I can't get them to pull only specific information for each order.

  5. #5
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Turn on report GROUPS in top bar icon (pictured)
    But groups and sorting is entered in the "footer" of the designer.
    Set the 1st sort (and if you want to see header or footers, etc)
    Then set the 2nd sort under the 1st one. Etc.

    Click image for larger version. 

Name:	rpt groups.png 
Views:	8 
Size:	28.5 KB 
ID:	16646

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

Similar Threads

  1. Giving a specific number to some data
    By Knelou in forum Forms
    Replies: 1
    Last Post: 09-12-2013, 08:45 PM
  2. Help using Dmax as an OrderID counter...?
    By acenumber5 in forum Access
    Replies: 8
    Last Post: 12-12-2012, 11:59 PM
  3. Replies: 6
    Last Post: 07-25-2011, 01:54 PM
  4. Replies: 5
    Last Post: 03-03-2011, 03:56 PM
  5. Replies: 0
    Last Post: 01-03-2011, 03:38 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