query headings out of order

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have several queries that I'm using for a summary report on how many times
each question was answered which way. I'm pulling the queries into the
reports just fine. There's only one issue: it's putting the options out of
order. Ex, instead of 100%, 90%, 75%, 50%, 25%, <25%... one question has
them listed in this order: <25%, 100%, 25%, 50%, 75%, 90%. Someone here
told me it was because I have them set as strings. However, with the <, >,
and % signs, I can't use numbers. Also, there are headings that *are* text.
For example, High, >Average, Average, and <Average are coming through in the
order of <Average, >Average, Average, and High. Anyone have any suggestions
as to how I fix that problem?

Much Appreciated!!

Seren
 
Seren said:
I have several queries that I'm using for a summary report on how many times
each question was answered which way. I'm pulling the queries into the
reports just fine. There's only one issue: it's putting the options out of
order. Ex, instead of 100%, 90%, 75%, 50%, 25%, <25%... one question has
them listed in this order: <25%, 100%, 25%, 50%, 75%, 90%. Someone here
told me it was because I have them set as strings. However, with the <, >,
and % signs, I can't use numbers. Also, there are headings that *are* text.
For example, High, >Average, Average, and <Average are coming through in the
order of <Average, >Average, Average, and High. Anyone have any suggestions
as to how I fix that problem?


That's the normal way of sorting text strings. If you are
sorting rows by these things, consider using an additional
field with a numeric value that will sort the way you want.

Since you mentioned headings in the subject line, I suspect
that you are doing this in a crosstab query. In this case,
you can use the query's Headings property to specify the
exact list headings to include in the field list as well as
their order.
 
Back
Top