Is there any way i can use an if statement in a report. What i want to do is say If column a = "yes" then textbox 1 = contents of column b Else textbox1 = contents of column c.

Try this as the control source of textbox1:

=IIf(ColumnA = "Yes", ColumnB, ColumnC)

Replacing with the actual field names.

Thanks Paul - can you use ElseIf as well

Yes, by nesting one IIf inside another:

=IIf(ColumnA = "Yes", ColumnB, IIf(ColumnA = "No", ColumnC, ColumnD))

Depending on what you're trying to do, it may be more practical to do it in VBA.

Thanks again Paul