TestResult is either a 0 or -0.000001

[dtruesdale04]

I need in the report for it to show that <0 is "Pres" and the >0 needs to "ABS". I have written the expression but end up with an error or it asking me for input for the results. The field already has the result I just need it interupted. It's a 2000 access DB and I'm using Access 2003. I used to be very proficient in Access but it's been 7 years since I have had to work in access.

 

[lupins46]

You ask one thing in the text of your post but the Subject line seems to be indicating a different issue.

You can create the text you want either in the query that is used for the report or in the report itself.

To get the text you want in a report you need to add a textbox to the report and set its controlsource property.
The controlsource should be something like:
=iif(testfield<0,"Pres",iif(testfield>0,"Abs", "0"))

obviously put your own fieldname instead of testfield.