How do i select a record using formula

[mamba74fr]

Hi all ,

I have my table like that i can print from sequel console.

Org.OrgID Org.Org Name Org.Course Org.Time
1145 MATH_DPT MATH 03/13/05
1146 PHYS_DPT PHYS 03/26/05
1147 BIOL_DPT BIOL 03/13/05
1148 ECON_DPT ECON 03/18/05
1149 MATH_DPT MATH 03/23/05
1144 FREN_DPT FRENCH 03/13/05


i would like to print to build a formula that allows me to select the record :
" 1149" when i give that 2 parameters : MATH and 03/23/05

i want to write something like

select O.OrgID from Org O where O.Course like 'MATH' and O.Time like '03/23/05'

or but much more something like

if {Org.Course}='MATH' and {Org.Time}='03/23/05' then {Org.OrgID}
else "" ;


Thank you a lot

 

[dgillz]

Please see the thread in Crystal reports 1 Formulas.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz