Sort for High, Medium, Low

[cookitup]

I amtrying to sort a query and a report to "high, medium, and low" I have looked at several threads on this forum to answer that question, But i guess i am still so new, i cant quite figure out how to do this. I have created a column for 'Priority", and "priority by number" to facilitate this but every time i try to use the IIf function, it doesnt work. Please help

 

[pbaldy]

Why don't you post the function so we can fix it?

 

[cookitup]

iif(Priority='H', 0, iif(Priority='M', 1, 2))
I put this in the Criteria: section of the query.

 

[pbaldy]

It doesn't sound like you want it in the criteria, rather as a field so you can sort on it. In a new field:

SortField: iif(Priority='H', 0, iif(Priority='M', 1, 2))

 

[cookitup]

That was all i needed, i knew i was putting it in the wrong section. Thanks a bunch

 

[pbaldy]

No problemo.

 

[cookitup]

New Problem, Works great in the query, but not in the report. The query is set up to only sort by the sort field created with the numbers for priority. What do you need to answer this question?

 

[pbaldy]

Have you set up the same thing in the report's Sorting and Grouping.

 

[cookitup]

Big duh...omn my part...I guess ive been too busy that i havent thought it out clearly! once again, Thanks for being my "thinking straight" brain!!! lol

 

[pbaldy]

Happy to help!