sorting dilemma

  • Thread starter Thread starter JohnE
  • Start date Start date
J

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
 
Use an expression in the Sorting and Grouping rather than the field name.
Perhaps something like:
=Nz([Priority Number Field],99999)
 
Bingo. That did it.
Thanks.


Duane Hookom said:
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


JohnE said:
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
Click to expand...
Click to expand...
 
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


Duane Hookom said:
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


JohnE said:
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
Click to expand...
Click to expand...
 
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


JohnE said:
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


Duane Hookom said:
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


JohnE said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top