Showing numbers as text

[Bloodrayne]

No sooner do I figure out something than I stumped by another,

I have an options box on my form - one that produces a number from 1 - 3 to indicate the priority of the task - 1 being the highest, 3 the low - these are shown up as numbers when a report is produced.

Question is: Is there anyway to make them display the appropriate text? So that 1 = High?

Thanks for any help

 

[Brianwarnock]

Hi its me again lunch time here so took a look

!st question in the query that is the record source for the report create a new fld txtPriority: iif(fldpriority=1,"High",iif(fldpriority=3,"Low","medium"))

and also fldcount:1
don't include this in the report detail but in the footer in an unbound text box put =sum([fldcount])

Brian

 

[Bloodrayne]

Hello again - thanks for taking the time out to help

I added to my query a new field, which looks like:

txtPriority: IIf([Priority]=1,"High",IIf([Priority]=3,"Low","Medium"))

Which doesn't seem to work, where have I gone wrong?

 

[stephen81]

Is the priority being stored as a number or as text. If it is being stored as text then I think you will need to enclose the numbers in your if statement in quotes.
i.e.

txtPriority: IIf([Priority]="1","High",IIf([Priority]="3","Low","Medium"))

 

[Bloodrayne]

No joy - I've tried both ways now - even though it should be stored as a number...

 

[Brianwarnock]

Works ok on my small test db

Check syntax fld names data selected.
What happens when you run the query?

 

[stephen81]

Also works fine on my test DB.

 

[Bloodrayne]

I'm having a bad day...

txtPriority: IIf([Priority]="1","High",IIf([Priority]="3","Low","Medium"))

Works just fine.....

Thanks for the help, the patience, and the lack of abuse...

Day'll be over soon..