Displaying records without Dates in the end of the section

[jkuruvil]

I need to print a report of a bunch of records that falls between certain dates. Some records have dates and some don't. I did a UNION query to look for everything that falls between these two dates and everything that have NULL in date fields. Records get sorted in an ascending order. So, now I do see all the records, but I like to display records without dates in the end with another title. How could I do this.

[MMcCarthy]

Set a group on the report by the Date field.

This will order all records by date.

I need to print a report of a bunch of records that falls between certain dates. Some records have dates and some don't. I did a UNION query to look for everything that falls between these two dates and everything that have NULL in date fields. Records get sorted in an ascending order. So, now I do see all the records, but I like to display records without dates in the end with another title. How could I do this.

[jkuruvil]

yes, I did that. But that displays all records without date at first, and then displays in ascending order everything with dates. What I like to see is display everything with dates in an ascending order and then in the end display all records without dates.
If it is possible to merge two reports, I don't mind doing that instead.

[MMcCarthy]

Create two subReports

1 with a record source where dates not null and the other with a record source where dates are null

yes, I did that. But that displays all records without date at first, and then displays in ascending order everything with dates. What I like to see is display everything with dates in an ascending order and then in the end display all records without dates.
If it is possible to merge two reports, I don't mind doing that instead.

[jimatqsi]

Or use this in your query to change the date to the last day of the century if it is null. You'll be changing the query result, not the date in the table
[code] TheDate:IIF (IsNull([datefield],12/31/99,[datefield])

That returns the date itself or 12/31/99 in field TheDate.

Jim