If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
sorting dilemma
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 |
#2
|
|||
|
|||
sorting dilemma
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" wrote: 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 |
#3
|
|||
|
|||
sorting dilemma
Bingo. That did it.
Thanks. "Duane Hookom" wrote: 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" wrote: 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 |
#4
|
|||
|
|||
sorting dilemma
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" wrote: 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" wrote: 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 |
#5
|
|||
|
|||
sorting dilemma
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" wrote: 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" wrote: 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" wrote: 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 |
Thread Tools | |
Display Modes | |
|
|