Order Report List non-alphabetically

  • Thread starter Thread starter PPCO
  • Start date Start date
P

PPCO

I have a report group with three items in it. Wondering if there is a way to
customize which item shows first? Thanks!
 
sure - you can add a field just for the purpose of controlling the
order...add it to the table itself. In the report this field does not have
to be visible.
 
It's coming from a query--I am auto generating text based on criteria. It's
the auto generated text that I'm using as my categories. So not sure how to
do that. Guess I could just add a number in front of the auto text
 
I have a report group with three items in it. Wondering if there is a wayto
customize which item shows first? Thanks!
Click to expand...

I have done the same thing in a query by setting a field A, B, C...
etc so that the items on the report can easily be groupped. For
example
I have a Query where it describes type of animal, Bird, Cat, Dog, and
I want the dog to appear first the bird to appear second and the cat
to appear last. With in the query I add a calculated field called
Sort and set the calculation up to be iif([type]='dog','A',iif([type]
='bird','B','C') and use this field to sort and group my report.

Hope that helps.
 
thanks, that will work.

vvariety said:
I have a report group with three items in it. Wondering if there is a way to
customize which item shows first? Thanks!
Click to expand...

I have done the same thing in a query by setting a field A, B, C...
etc so that the items on the report can easily be groupped. For
example
I have a Query where it describes type of animal, Bird, Cat, Dog, and
I want the dog to appear first the bird to appear second and the cat
to appear last. With in the query I add a calculated field called
Sort and set the calculation up to be iif([type]='dog','A',iif([type]
='bird','B','C') and use this field to sort and group my report.

Hope that helps.
Click to expand...
 
Back
Top