Grouping a report

P

Pedro

Hi everyone
I'd like, one of the grouping levels, to be a control wich has only 2
possible values : yes and no. When i'm done that report it shows me the
values 0 and -1 that means true and false. I'd like to show me "Result :
True" and "Result : False"
I think it's something like this : =" Result: " & [Concil Banco] Format
(True/False) but i know it's not this.
Can you help me please?
Regards
Pedro
 
D

Duane Hookom

Try:

="Result: " & IIf([Concil Banco],"True","False")

Make sure the name of the text box is not the name of a field.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to Select text from a point given to a specific word 2
Grouping and Sorting a Report On Open Event 5
Grouping a Report made with a cross tab qry 11
weird sum on report 2
Sorting/Grouping question on report 2
Coordinating the sort order in a report with the underlying query 2
Grouping a report 1
Multi level grouping in a report 2

Top