Results 1 to 4 of 4
  1. #1
    Emmanuel is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2020
    Posts
    272

    Report to appear exactly as it appears in query

    I created a query to a table which is arranged in the way I want. I therefore created a report based on that query but unfortunately, am not getting the report arranged exactly as it appears in the query.



    Is there a way to configure the report to display the data exactly as it appears in then query?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    If you mean sort, reports override the query sort.
    click the Sort & Group icon ,add the fields you need.

  3. #3
    Emmanuel is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2020
    Posts
    272
    Quote Originally Posted by ranman256 View Post
    If you mean sort, reports override the query sort.
    click the Sort & Group icon ,add the fields you need.
    Noted. Let me give it a try and see how it goes

  4. #4
    Emmanuel is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jan 2020
    Posts
    272
    The group and sort did the trick. Thanks

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

Similar Threads

  1. Report Header - appears only with click
    By ClassyD in forum Reports
    Replies: 1
    Last Post: 07-02-2017, 11:46 AM
  2. Replies: 6
    Last Post: 05-25-2015, 12:42 AM
  3. Replies: 5
    Last Post: 09-12-2014, 06:41 AM
  4. report the # of times a name appears in a field
    By rankhornjp in forum Reports
    Replies: 25
    Last Post: 08-04-2011, 01:45 PM
  5. Function: add date when record appears on report
    By Theremin_Ohio in forum Reports
    Replies: 1
    Last Post: 05-17-2011, 08:03 AM

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