substitute number for string

[Andrej]

Hello
I'm novice user of access so now at final point I have problems that I don't know how to resolve
I have a columns of environmental data that i want to present in the Report

My problem is that, some values(like 0.005) at report I have to change for value of string(<0.01).

is it possible to do it in report or you have to do in query
many thanks in advance

 

[pbaldy]

Either one. You can use the IIf function to test the value of the field, and place your string in there when appropriate. More info on that function in Help.

 

[Andrej]

sorry, but I'm very green in the programing
could you put me some example that I can put in the VB and use
IF "value of column of query or report"=0,1 THEN "change with"="<0.1"-in the report
My problem is than I don't know when to put "" or [[]] in VB and how to call some column in specific table or query
I was trying a lot,but no (suc)ccess
thanks again

 

[Kinger43]

You don't have to use VB. Open the properties for the text box in your report and put the iif statement in the control source field under the All tab.

 

[Andrej]

hay
this is great solution for user like me, but when I put in the box statement:
=iff([name of column]<1;"<1";[name of column])
aether
=iff([name of column]<1;"<1";">1")
in the column of the report I get #Error
thx for response

 

[Kinger43]

Don't need two iif statements

Your syntax isn't quite right. It should look more like this

=iif([columnname]<1,"<1",">1")

Essentially what this says, is that if [columnname]<1 then put <1 in the text box and if it is not <1 then put >1 in the text box.

I may not be understanding exactly what you want though

 

[Andrej]

you understand my problem, and you give to me great solution but still I have a error in the report
I changed [ ; ] for [ , ] and report didn't want to show aether error column and says to me that syntax's is wrong.
Is it possible that Spanish windows and Access have different syntax? On the other (spanish language) I find syntax with [ ; ] and in English pages [ ,]

 

[pbaldy]

Make sure there isn't a control with the same name as the field, as that will often cause a problem. If you used the wizard to create the report, then there probably is (pet peeve of mine).

 

[Kinger43]

You are probably right about the [;] versus [,]. Also make sure that [columnname] isn't the same as the text box name that you are defining. If this is the case it usually gives you an error about a circular reference.

 

[Andrej]

IT WORKS!!! also in Spain
thanks both of you,
you realy halped me a lot

 

[pbaldy]

No problemo. My daughter spent 6 months in Spain and loved it. We're hoping to take a family trip there so she can show us around.