sorting dilemma

[JohnE]

I have a report that displays items. Some of these items are ranked by a
priority number. Some are not. In sorting in asc order, those with no
priority number go to the top of the list then the ranked ones follow. I
need to reverse that and place the ranked ones at the top of the list (in
order) followed by the non priority one.

How can that be done in an A2007 report?

Thanks. John

 

[Duane Hookom]

Use an expression in the Sorting and Grouping rather than the field name.
Perhaps something like:
=Nz([Priority Number Field],99999)

 

[JohnE]

Bingo. That did it.
Thanks.

Use an expression in the Sorting and Grouping rather than the field name.
Perhaps something like:
=Nz([Priority Number Field],99999)

--
Duane Hookom
Microsoft Access MVP

I have a report that displays items. Some of these items are ranked by a
priority number. Some are not. In sorting in asc order, those with no
priority number go to the top of the list then the ranked ones follow. I
need to reverse that and place the ranked ones at the top of the list (in
order) followed by the non priority one.

How can that be done in an A2007 report?

Thanks. John

 

[JohnE]

Mr Hookum, could I inquire with you another report issue that could be a
minor thing. On a report I have a series of subreports. Some of the srpts
have info and some do not. When the report is printed out, the srpt control
is not there when no data available so I would like to have a label under the
person's name say something about not data. Label, even positioned behind
the control still shows thru.

Any suggestions?

Thanks...John

Use an expression in the Sorting and Grouping rather than the field name.
Perhaps something like:
=Nz([Priority Number Field],99999)

--
Duane Hookom
Microsoft Access MVP

I have a report that displays items. Some of these items are ranked by a
priority number. Some are not. In sorting in asc order, those with no
priority number go to the top of the list then the ranked ones follow. I
need to reverse that and place the ranked ones at the top of the list (in
order) followed by the non priority one.

How can that be done in an A2007 report?

Thanks. John

 

[Duane Hookom]

You can use a text box with a control source like:
=IIf(subrptControlname.Report.HasData, Null,"This person does not exist to
me;-)")

--
Duane Hookom
Microsoft Access MVP

Mr Hookum, could I inquire with you another report issue that could be a
minor thing. On a report I have a series of subreports. Some of the srpts
have info and some do not. When the report is printed out, the srpt control
is not there when no data available so I would like to have a label under the
person's name say something about not data. Label, even positioned behind
the control still shows thru.

Any suggestions?

Thanks...John

Use an expression in the Sorting and Grouping rather than the field name.
Perhaps something like:
=Nz([Priority Number Field],99999)

--
Duane Hookom
Microsoft Access MVP

I have a report that displays items. Some of these items are ranked by a
priority number. Some are not. In sorting in asc order, those with no
priority number go to the top of the list then the ranked ones follow. I
need to reverse that and place the ranked ones at the top of the list (in
order) followed by the non priority one.

How can that be done in an A2007 report?

Thanks. John