Search:

Type: Posts; User: Dwaynewayne

Search: Search took 0.01 seconds.

  1. Replies
    3
    Views
    3,903

    Re: convert currency sql

    thank you very much thetimmer
  2. Replies
    3
    Views
    3,903

    convert currency sql

    (
    @Amount DECIMAL(18,2),
    @Freight DECIMAL(18,2),
    @FreightName VARCHAR(500)

    )
    AS
    SELECT FreightName,

    CASE WHEN (FreightName= @FreightName) And (UseFreight = 'TRUE') THEN
  3. Replies
    8
    Views
    3,326

    Re: calculate from data table

    yes that is what i want just the value in the row what i dont want to so is every time i add a new row i have to write a line of code
    i am pretty much a newbie to this i am about a week in to...
  4. Replies
    8
    Views
    3,326

    Re: calculate from data table

    i am in to shipping of cars and there are ways and mean of transporting them. if i am going by sea i use CIF, CFR, FOB
    CIF mean i bought the with freight and insurance into the price. so my...
  5. Replies
    8
    Views
    3,326

    Re: calculate from data table

    no the text box wont be left blank it will always have a value the reason it need to be 0 if check in case some one place a value in the check box it will turn it in to 0 as that CFR mean the freight...
  6. Replies
    8
    Views
    3,326

    calculate from data table

    'i have a tblFreightdataset with the following Coloum and row
    ID FreightType Value FrightValue
    1 CIF 0.00 []
    2 FOB 0.015 []
    3 CFR 0.015 ...
  7. Re: filter to find between value in two column from the same row

    your first suggestion work what i had wrong was my table was set to varchar(50) and not int so after i change it then it was good thanks again
  8. Re: filter to find between value in two column from the same row

    it did not work can a if statement be us?
    if i change the following it work but i want ti be able to change the number value from a text box
    SELECT Importer,Fruits, ValueFrom, ValueTo
    FROM...
  9. filter to find between value in two column from the same row

    my dataset is as follow

    Importer| Fruits |ValueFrom |ValueTo
    Mark Banana $1 $10
    Mark Banana $11 $20
    John Banana $1 $10
    John ...
Results 1 to 9 of 9



Click Here to Expand Forum to Full Width