query headings out of order

S

Seren

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
 
M

Marshall Barton

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?
Click to expand...


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.
 
Top