Re: Don't sort

Tech-Archive recommends: Speed Up your PC by fixing your registry



Can't you sort first by Sex and then by Person1 DESC?

If you want to see records in a specific order (entered order is an order)
then you must have a value stored in a field or fields that describe that
order.

--
Duane Hookom
MS Access MVP
--

"Brad" <Brad@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F2703E34-D98C-4B64-8CA3-C11F34620540@xxxxxxxxxxxxxxxx
> Thanks for taking the time to read my question
>
> I have a table that looks like the following
>
> Sex Person1 Person2 Person3
> M Bert Henry Garry
> M 21 31 23
> F June Jill Mary
> F 24 25 21
>
> I put the data into this table from another table just for this report
>
> I want my report to group on Sex, and then show the data just as it is in
> the table. However, Access insists on sorting the data so that the
> numbers
> show first and the names second. If I put a sort order on Person1 then it
> puts both name rows first, then the ages.
>
> Can I turn off the auto sort at all?
>
> Brad


.



Relevant Pages

  • Re: Dont sort
    ... so I'll just sort the records by the autonumber within the groups. ... "Brad" wrote: ... > My report has the persons name and under it their age. ... > I need the report to look exactly like the table, just grouped on Sex. ...
    (microsoft.public.access.reports)
  • Re: Dont sort
    ... My report has the persons name and under it their age. ... Report Sorted Ascending on Person1, and Decending and Grouped on Sex will ... I need the report to look exactly like the table, just grouped on Sex. ... > Can't you sort first by Sex and then by Person1 DESC? ...
    (microsoft.public.access.reports)
  • Re: Report in FM 6 or 7
    ... Please adivse on this- and then, I get to attack this report again in ... you cannot sort by AgeDivision_Category and why the Export/Import ... act they want to be the last act of the show, they have to sort by their ... If the Age Division field contains data in the form "3-5 Age Division" ...
    (comp.databases.filemaker)
  • Re: Report in FM 6 or 7
    ... Please adivse on this- and then, I get to attack this report again in ... you cannot sort by AgeDivision_Category and why the Export/Import ... act they want to be the last act of the show, they have to sort by their ... If the Age Division field contains data in the form "3-5 Age Division" ...
    (comp.databases.filemaker)
  • Re: sort in report
    ... "fredg" wrote: ... date on my report. ... fields I would like to sort on in a report: ... so the format is irrelevant). ...
    (microsoft.public.access.gettingstarted)