RowSource formula need help

M

miles

hi

i need help

Term = CIF
Buying price * 10% = Landed cost

Term = FOB
Buying price * 15% = landed cost

term = Other

in my form it is in combo box "CIF", "FOB", "other"

how to link them using query??
wat formula

i need something like that
If term = "CIF" then buying price *10% = landed cost
if term = "FOB" then buying price * 15% = landed cost
Else buying price = landed cost

but i did not how to make it in query
do i need rowsource???

urgent pls help
thank
 
0

03321Áõ³£¹ð

miles said:
hi

i need help

Term = CIF
Buying price * 10% = Landed cost

Term = FOB
Buying price * 15% = landed cost

term = Other

in my form it is in combo box "CIF", "FOB", "other"

how to link them using query??
wat formula

i need something like that
If term = "CIF" then buying price *10% = landed cost
if term = "FOB" then buying price * 15% = landed cost
Else buying price = landed cost

but i did not how to make it in query
do i need rowsource???

urgent pls help
thanks
Click to expand...
 
B

Broadway

not really sure why you need to link them in a query, do it as part of the
form to place in "landed cost"

try using if else statements for instance, put into the after update of the
combobox

If me!"combobox name" = "cif" then
buying price * .10 = landed cost
else
if me!"combobox name" = "fob" then
buying price * .15 = landed cost
else
buying price = landed cost
endif
endif
endif
 
Top