|
Subject:
|
Looking Up Values In Other Fields
|
|
Posted By:
|
meista
|
Post Date:
|
12/11/2006 6:50:31 AM
|
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
|
|
