I am almost done with a comparison report than has multiple fields. The report is grouped by department code then item number, then dates. I am comparing yesterdays orders to today's orders.

Here is my issue. I would like my report to filter by my two date fields in ascending order not one field then the next but consecutively. I can attach the report if needed.

Thanks for you help.

attaching the database rather than just the report would be of more assistance.

This is an unusual request but you would have to concatenate the two fields together in order to do it - so an example of your two fields worth of data and how you would expect them to be sorted would be helpful (if the database is not forthcoming).

Thanks for your reply, I found a work around.

IIf([CS comparison Table]![P-PROM_DLVRY],[CS comparison Table]![P-PROM_DLVRY],[CS comparison Table]![C-PROM_DLVRY])

This gives me a new field that I made not visible on the report.