Re: Is it possible to get a report where every column is sorted the way I want it?

From: Rick B (Anonymous)
Date: 11/29/04 

Date: Mon, 29 Nov 2004 11:20:07 -0600

Typically, each line is a record where the first column might be the name,
second might be the address, etc. If you 'sort' them diffferently, then the
report would make no sense. If the first line contains Bob's name, then
address, then phone number, then birthdate, you would not want to move his
birthdate to another line by sorting that column.

If you want to sort the entire report based on mutliple columns (fields or
controls) then you would jsut put multiple items in your sort/group box. In
the above example, if you have two lines with the name "Bob" you can
certainly use the address as your second sort criteria. But, the entire
line is moved up or down.

You might want to post more details on what your database structure is.

Rick B

"PeterGundrum" <pgundrum1@wi.rr.com> wrote in message
news:9bff01c4d636$6b24ac00$a401280a@phx.gbl...
> Or a form?
>
> Is there some way I can get a report where if I have 6 or 7
> columns and I want to sort them different ways?
>
>
> Do I have to use subreports or forms or what?
>
>
> I hope you understand what I mean. Any help would be
> appreciated.

Relevant Pages

  • Re: sort and matching cells
    ... sort the first column. ... Use a second range object to point to the first cell in column B then ... if they don't match insert cells moving rows down(again a record macro ... sort the first column and use a vlookup to match the other valuse ...
    (microsoft.public.excel.programming)
  • Re: Sorting two columns of data
    ... you can record a small macro to cut the second column ... and paste it to the bottom of the first column, then select it and sort, ... > My intent was to be able to import data from a database and have the sort ...
    (microsoft.public.excel.worksheet.functions)
  • GridView and multiple column sorting: is this a bug?
    ... I have a GridView control that I want to sort on multiple columns when I ... name in the first column and display id in the second column. ... on the first column, I want the GridView to sort on LastName and FirstName. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Sorting address lists that are in 2 columns
    ... Do the same for the first column of addresses. ... then select the empty column in the names table, ... If you want to sort text in two columns in Word, ... in a text box, it sorts everything, separating names from addresses. ...
    (microsoft.public.word.docmanagement)
  • Re: macro: sort list, then print w/out blank rows
    ... autofilter and print the visible range: ... The first column by which I sort is sorted in Ascending order. ... When I let the macro print the range, ...
    (microsoft.public.excel.misc)