embedding an if statement

[soda]

i am trying to embed an IF statement within a control source on a text file in a report? Is this do-able?

I've tried:

= if [date] > #01/01/01# then "no picture"

&

= if ([date] > #01/01/01#, "no pic", "&quot

not sure what to do now...

Thanks,
John

 

[Dreamboat]

=iif([date]>#01/01/01#,"no pic","&quot

IIF is used in Access, not IF
techsupportgirl@home.com

http://www.PiersonTech.com

Brainbench MVP for Microsoft Word