sorting by date

[Guest]

I have a report that has a customer number, a date and the product type and
then the number of items. I am sorting by customer number, then date, then
product. The sort is working for customer number and product but not the
date. I have the sort set to ascending, with no group header or footer, I
group on each value with a group interval of 1. Any ideas why this sort
isn't working?

 

[Rick B]

What does "not working" mean?

Is the field actually a date/time field in the table?

What exactly is entered in your grouping and sorting box in the report
design?

 

[Marshall Barton]

I have a report that has a customer number, a date and the product type and
then the number of items. I am sorting by customer number, then date, then
product. The sort is working for customer number and product but not the
date. I have the sort set to ascending, with no group header or footer, I
group on each value with a group interval of 1. Any ideas why this sort
isn't working?

Sounds like your date field is a Text field. Try seting the
sort to =CDate(datefield)