Report Sorting Problem


G

Guest

I posted an earlier question regarding this, but still haven't been able to
solve the issue. I work for a company that installs windows in homes. I've
been asked to create a "Collections" report that is sorted 1st by "Collection
Date". If there is no Collection date, sort by "Start Date". If there is no
Start Date, sort by "Sale Date". My boss doesn't want the "Sale Date" field
to appear on the report. I created a query that includes all three fields,
and have the "Sale Date" field sorted Ascending, and unchecked so that it
doesn't show in the query. What changes do I have to make to the query so
that the report will sort in the above order? Another way of describing it
is: if there is no Collection Date, sort by Start Date. If there is no Start
Date, sort by Sale Date. Please help!!!

ricseb
 
Ad

Advertisements

J

John Spencer

The sort order of a query that is the source for a report is I G N O R E D
by the report..

You need to include the all three date fields in the query, so you can use
them in the reports Sorting and Grouping. (Menu: View: Sorting and Grouping
....)

Then set the sort in the reports Sorting and Grouping dialog as

= NZ([CollectionDate],Nz([Start Date],[Sale Date]))

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..
 
Ad

Advertisements

G

Guest

Thanks John. I'll try that.

Ricky Sebastian

John Spencer said:
The sort order of a query that is the source for a report is I G N O R E D
by the report..

You need to include the all three date fields in the query, so you can use
them in the reports Sorting and Grouping. (Menu: View: Sorting and Grouping
....)

Then set the sort in the reports Sorting and Grouping dialog as

= NZ([CollectionDate],Nz([Start Date],[Sale Date]))

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..

ricseb said:
I posted an earlier question regarding this, but still haven't been able to
solve the issue. I work for a company that installs windows in homes.
I've
been asked to create a "Collections" report that is sorted 1st by
"Collection
Date". If there is no Collection date, sort by "Start Date". If there is
no
Start Date, sort by "Sale Date". My boss doesn't want the "Sale Date"
field
to appear on the report. I created a query that includes all three
fields,
and have the "Sale Date" field sorted Ascending, and unchecked so that it
doesn't show in the query. What changes do I have to make to the query so
that the report will sort in the above order? Another way of describing
it
is: if there is no Collection Date, sort by Start Date. If there is no
Start
Date, sort by Sale Date. Please help!!!

ricseb
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top