Re: Sorting / Grouping and sorting in the stored procedure

"Gabriele Bertolucci" <"info[at]pbsoft[dot]it"> wrote in message
news:ydme52qmue6f$.svkukoj8wudo$.dlg@xxxxxxxxxxxxx
I have a fairly dynamic selection screen for user input for report
criteria
including sort fields and Top n (records or percent or Ntile).

Up to this point I have allowed Access to sort the returned record set
based
upon Sorting and Grouping criteria. To my knowledge you can¢t turn this
off
short of deleting the grouping. With the addition of Top / Rank criteria
the
sp MUST sort / rank to return the proper records.

My questions is if the retuned record set is presorted, does this help,
hurt
or have no effect upon the access report?

When you use "Sorting and Grouping" feature, Access ALWAYS group/sort
AGAIN
the recordset that is returned, independently from what is the data
source.
Seo, if you want to sort/group data in a report, I suggest you to avoid
sorting or grouping in a stored procedure and let Access do this job.

Not only that, but you cannot be sure that Access will respect the order of
the incoming data.

I agree with Garbriele that you should let Access do the sorting for you.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)



.

Relevant Pages

  • Re: Sorting / Grouping and sorting in the stored procedure
    ... Up to this point I have allowed Access to sort the returned record set based ... When you use "Sorting and Grouping" feature, ...
    (microsoft.public.access.adp.sqlserver)
  • VBA - Flexible Sort Macro
    ... In Excel 2003, I know you can have three criteria of sorting (Sort by, ... (representing columns D through I of the sheet) ...
    (microsoft.public.excel.programming)
  • Re: Sorting / Grouping and sorting in the stored procedure
    ... I have no choice to do the sort in the sp and, ... upon Sorting and Grouping criteria. ... or have no effect upon the access report? ... When you use "Sorting and Grouping" feature, ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Excel Type Sorting ???
    ... I think you want to sort on multiple criteria, ... Thing is I don't want the order of A to change when sorting B and i ... using a sort sub something like this: ...
    (perl.beginners)
  • Re: repost: connect two rows of data
    ... > that carries the Grand Total for sorting. ... the excel sorting feature then help - nothing!) ... if this is not possible make columns that are representing the sort ... criteria, then you can concatenate the criteria to ...
    (microsoft.public.excel.programming)
Quantcast