Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

RE: RowSource formula need help

Discussion in 'Information Technology' started by Broadway, Nov 10, 2005.

  1. Broadway

    Broadway
    Expand Collapse
    Guest

    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


    "miles" wrote:

    >
    > 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
    >
    >
    > --
    > miles
    >
     
  2. Loading...


Share This Page