Query

[Former Member]

Hey Guys

Tthese are my UDF in Qutation Layout.

OQUT.U_Layers.OQUT.U_Area,OQUT.U_GSM,QUT1.U_CALCFact1,

QUT1.Quantity

I want to build one Query

If qut1.u_CALCFact1.number = 1

then QUT1.Quantity= oqut.u_Layers.numberoqut.u_Area.numberoqut.u_GSM.number or

If qut1.u_CALCFact1.number =2

then QUT1.Quantity= (oqut.u_Layers.numberoqut.u_Area.number)2

Otherwise the quantity field remain 1

Can any one help me.

Thanx in advance

Edited by: Cool Guy on Apr 6, 2008 6:05 PM

[Former Member · Accepted solution]

Hey Cool Guy,

Are you looking for this to be an update query or just viewing/reporting the data ?

It appears to me that you are looking to update the quantity field in the QUT1 table, is this correct ?

Regards,

Eli Lawson

Florida, USA

[Former Member]

Ya you got my point and my problem is solved.