Good Morning,

Just can not get my head around the following and am sure there is a simple way around this.

In Crystal reports, I just want to create a lookup-type formula which will display a certain value from the same table.

Example:

Ref Value IF R?
---- ------- ------
10 £100 £500
11 £200 £0
12 £300 £600
R10 £500 £0
R12 £600 £0

So simply, at each line, the 'IF R' formula would in turn look at the ref fields and display the Value if there is an existance of an R** ref.

Would I have to create a subreport to achive this?

Thank you in advance for your response.

Paul Carruthers