Annoying me...

[Rogue Programme]

I have a query that throws out results by month.

When i open the query i get the correct results however, the results are not in date order...for example:

Instead of Jul-03, Aug-03, Sep-03 etc....

It's showing date in alphabetical order, for example:

Aug-03, Jul-03, Sep-03!

I have also created a chart to show a visual comparison and the same is happening..the dates are in alphabetical order rather than date order.

grrrhhhhhhhhh!!!!

Cheers

Mike

 

[namliam]

Dont sort on the string but on the real date in your table....

Just dont show the date in the result of the query...

Regards

The Mailman

 

[Rogue Programme]

I get what your saying but i still need the date to show in the report...

I'll have a go

Cheers

 

[namliam]

I get what your saying but i still need the date to show in the report...

I'll have a go

Cheers

You dont need the DATE (eg 12 aug 2003) to show you want the Aug-03 to show...

Sort on the real date (eg 12 aug 2003) and see what happenes. If its an agregate query (group by) Then you will need to do a CVDATE("01-" & "Aug-03") to the query (if you get what i mean) and the sort on that....

Regards....

The Mailman

 

[Rogue Programme]

Sorted, don't really know how, but it's sorted...

Thanks for your help

Mike

 

[Rogue Programme]

by the way i did query on the real date then reformatted that date as follows..

ForMonth: Format([Calldate],"mmm yy")

And then sorted on that and it seemed to work.

Mike