problem using if statement in report! need help!

[gino]

i know...reports and forms function differently but i know there is a way of doing this.

rather than using event i used this expression for the POINTS field for the control source.

=iif([ACCURACY]>=89, "MEETING", "NOT MEETING")

seems like its not reading the data right because i get "MEETING" for all the records. is there another route of doing this or is my formula incorrect? also, does the format have to do with it?

thanks to all in advance!

[This message has been edited by gino (edited 06-19-2000).]

 

[Carol]

Try the following:
=IIf([ACCURACY]>="89","MEETING","NOT MEETING")
if this does not work then set it up in your underlying query as a new field and reference this field as your control source in your report, as follows:
NewFieldName: IIf([ACCURACY]>="89","MEETING","NOT MEETING")
Good luck

[This message has been edited by Carol (edited 06-19-2000).]