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