Is it possible to sort on more than 3 fields?

External Since: Jun 23, 2008 Posts: 18

The ContactDate is a Date/Time field, what I'm getting appears to be random,
sometimes it's right, other times it's not. There doesn't appear to be any
logic in the way it is sorting.

"Rick Brandt" wrote:

> Jane Schuster wrote:
> > Sorry. I didn't mean to be cryptic. Let's say, I have the following:
> >
> > Business: ABC Machines
> > LastName: Smith
> > FirstName: Bob
> > ContactDate: 01/01/2008
> > ContactDate:02/01/2008
> > ContactDate: 03/01/2008
> > Business: BCD Machines
> > LastNate: Smith
> > FirstName: Bob
> > ContactDate: 01/01/2008
> > ContactDate: 02/01/2008
> > ContactDate: 03/01/2008
> >
> > That's how I want the report to print (well, I want it to print in
> > descending order by ContactDate, but it isn't doing that either,
> > although that's what I specified on the Sorting and Grouping Screen).
> > I've got the first sort on Business, the second on LastName, the
> > third on FirstName, and the fourth on ContactDate.
>
> You haven't indicated the sort that you ARE getting. Almost certainly your
> dates are being sorted as text because you have an expression that is
> converting them from dates to strings.
>
> If the data in a field looks like a date there are really only two possible
> ways for the sort to be applied, chronological, or alphabetical. If you are
> getting the latter then you have to find out where your dates are being
> changed into strings. Use of the Format() function is the most common
> reason.
>
> --
> Rick Brandt, Microsoft Access MVP
> Email (as appropriate) to...
> RBrandt at Hunter dot com
>
>
>

External Since: Nov 04, 2004 Posts: 3937

Jane

You aren't perceiving any pattern ... but we still don't have an example of
how it is sorting, so we can't offer our ideas about what might be
happening.

Regards

Jeff Boyce
Microsoft Office/Access MVP

"Jane Schuster" <JaneSchuster.RemoveThis@discussions.microsoft.com> wrote in message
news:C345DE10-F2FC-42B5-86B2-2E8708C324FA@microsoft.com...
> The ContactDate is a Date/Time field, what I'm getting appears to be
> random,
> sometimes it's right, other times it's not. There doesn't appear to be
> any
> logic in the way it is sorting.
>
> "Rick Brandt" wrote:
>
>> Jane Schuster wrote:
>> > Sorry. I didn't mean to be cryptic. Let's say, I have the following:
>> >
>> > Business: ABC Machines
>> > LastName: Smith
>> > FirstName: Bob
>> > ContactDate: 01/01/2008
>> > ContactDate:02/01/2008
>> > ContactDate: 03/01/2008
>> > Business: BCD Machines
>> > LastNate: Smith
>> > FirstName: Bob
>> > ContactDate: 01/01/2008
>> > ContactDate: 02/01/2008
>> > ContactDate: 03/01/2008
>> >
>> > That's how I want the report to print (well, I want it to print in
>> > descending order by ContactDate, but it isn't doing that either,
>> > although that's what I specified on the Sorting and Grouping Screen).
>> > I've got the first sort on Business, the second on LastName, the
>> > third on FirstName, and the fourth on ContactDate.
>>
>> You haven't indicated the sort that you ARE getting. Almost certainly
>> your
>> dates are being sorted as text because you have an expression that is
>> converting them from dates to strings.
>>
>> If the data in a field looks like a date there are really only two
>> possible
>> ways for the sort to be applied, chronological, or alphabetical. If you
>> are
>> getting the latter then you have to find out where your dates are being
>> changed into strings. Use of the Format() function is the most common
>> reason.
>>
>> --
>> Rick Brandt, Microsoft Access MVP
>> Email (as appropriate) to...
>> RBrandt at Hunter dot com
>>
>>
>>