469,913 Members | 2,683 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,913 developers. It's quick & easy.

Displaying records without Dates in the end of the section

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.
Oct 19 '06 #1
4 1482
MMcCarthy
14,534 Expert Mod 8TB
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.
Oct 20 '06 #2
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.
Oct 20 '06 #3
MMcCarthy
14,534 Expert Mod 8TB
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.
Oct 20 '06 #4
jimatqsi
1,263 Expert 1GB
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
Oct 20 '06 #5

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.