Dear john
Yes I do have grouping on OrderID, but I dont want any sort order in my report, I want that as the data enter on my form it should be reflected as it is on the report
Thanks & Regards,
--
Abdul Shakeel
________________________________
From: John Viescas <john@viescas.com>
To: MS_Access_Professionals@yahoogroups.com
Sent: Tuesday, November 1, 2011 12:21 PM
Subject: RE: [MS_AccessPros] Report Sort Problem
Abdul-
Do you have any Grouping defined in the report? Would you prefer that the data
sort ascending? The Access report engine builds its own query to try to most
efficiently fetch the data required, and it may apply a sort. If you want the
data sorted some other way, you have to specify it.
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Abdul Shakeel
Sent: Tuesday, November 01, 2011 7:43 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Report Sort Problem
Dear All,
I have made a report based on a query, the report have not any sort order
neither the query but, when I preview the report, its detail section is sort
descending, how I remove this sort order.
Thanks & Regards,
--
Abdul Shakeel
[Non-text portions of this message have been removed]
------------------------------------
Yahoo! Groups Links
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar