Order of records in a report.

  • Thread starter Thread starter CEVisker
  • Start date Start date
C

CEVisker

I have built a Report based on a Query that I have made. Each record has
2 date fields along with other fields: 1st is start date, 2nd is stop
date. The stop date is not always populated until we put a date in
there. On the report, I would like to list first all records that do
not have a stop date in order. After these, I would like to list the
records that have a stop date.

In other words, when it comes time to enter a date for the stop date, I
would like that record to then be moved to the bottom of the report
with the rest of the records that have a stop date. I think there must
be some way of doing this, but am not sure how. I tried the ascending
order for both fields in the query properties, but that is not it. If
someone can explain in a language a newbie would understand, I would
greatly appreciate it.

Thank You,

Chad
 
I have built a Report based on a Query that I have made. Each record has
2 date fields along with other fields: 1st is start date, 2nd is stop
date. The stop date is not always populated until we put a date in
there. On the report, I would like to list first all records that do
not have a stop date in order. After these, I would like to list the
records that have a stop date.

In other words, when it comes time to enter a date for the stop date, I
would like that record to then be moved to the bottom of the report
with the rest of the records that have a stop date. I think there must
be some way of doing this, but am not sure how. I tried the ascending
order for both fields in the query properties, but that is not it. If
someone can explain in a language a newbie would understand, I would
greatly appreciate it.

Thank You,

Chad
Click to expand...

First of all, any sort order you may have in the query is irrelevant
to a sort order in the report.
To properly sort records in a report, you must use the report's
Sorting and Grouping dialog:
View + Sorting and Grouping.

Set the first level of Sorting on the [Stop Date] field, Ascending.
 
I beleive that worked, I will have to enter some more test data to fin
out for sure, but it looks good so far. I had the start date listed a
the first sort order. Now it makes sense if you have the stop dat
listed first and there is no data in that field, then they would b
listed first in the report.

Thanks for the response,

Cha
 
I beleive that worked, I will have to enter some more test data to fin
out for sure, but it looks good so far. I had the start date listed a
the first sort order. Now it makes sense if you have the stop dat
listed first and there is no data in that field, then they would b
listed first in the report.

Thanks for the response,

Cha
 
I beleive that worked, I will have to enter some more test data to fin
out for sure, but it looks good so far. I had the start date listed a
the first sort order. Now it makes sense if you have the stop dat
listed first and there is no data in that field, then they would b
listed first in the report.

Thanks for the response,

Cha
 
I beleive that worked, I will have to enter some more test data to fin
out for sure, but it looks good so far. I had the start date listed a
the first sort order. Now it makes sense if you have the stop dat
listed first and there is no data in that field, then they would b
listed first in the report.

Thanks for the response,

Cha
 
Back
Top