Results 1 to 3 of 3
  1. #1
    John_sc is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2015
    Location
    South Carolina
    Posts
    34

    Report is not using the data from a query

    I have Windows 10, Access 365. I created a simple table with two files - name and age. Entered some data, then created a query which displays both fields and sorts on age Ascending. Looking at the query results it shows the data correctly with the age sorted. Saved the query as Query1

    Then I clicked on the query and created a report. The report Data Source says it is using Query1, but the data is not sorted by the age - it is displayed as if it were using the underlying table.



    I have searched but I have not been able to find any discussion of this issue. Any idea what the problem is? I can upload the database or screen shot if that would be helpful.

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,861
    Reports have their own sorting (and grouping)
    Source sorting is ignored
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #3
    John_sc is offline Advanced Beginner
    Windows 7 64bit Office 365
    Join Date
    Sep 2015
    Location
    South Carolina
    Posts
    34
    That did the trick. Thanks for the info. I thought in a previous version they did use the source sorting, but I may be mistaken. Thanks for replying so quickly!

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

Similar Threads

  1. Replies: 2
    Last Post: 09-17-2019, 08:38 AM
  2. Replies: 4
    Last Post: 09-17-2018, 10:15 AM
  3. Replies: 27
    Last Post: 08-14-2012, 09:05 AM
  4. Replies: 5
    Last Post: 10-06-2011, 05:49 PM
  5. Report different from query data
    By philbill in forum Reports
    Replies: 2
    Last Post: 10-11-2010, 03:56 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