sorting by date

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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?
 
bill said:
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?
Click to expand...


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