Report does not respond - Microsoft Access Beginner 9


	Back to Access Beginner 9 Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Report does not respond

Emad Al-Baghli

5 years ago

I have Query for Contact and it sorted by date Descending, If I run the Query itself it is working good, then I create Report based on that Query, If i run the report the report did not sorted by date. what do you think the problem is?

	Adam Schwanz @Reply 5 years ago
Just change the report's sort by property. Report properties -> Data -> Order by

	Emad Al-Baghli OP @Reply 5 years ago
Adam, kindly can write the code for me?

	Adam Schwanz @Reply 5 years ago
I don't know what your field name is that you're sorting by. Just go to that spot and do something like [WarrantyT].[QuoteDate] DESC with your fields

	Richard Rost @Reply 5 years ago
Sorting and grouping in a REPORT will override any sorting in the underlying QUERY. See Sorting and Grouping.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Beginner 9.

Next Unseen

New Feature: Comment Live View