Post reply

SQL for Execl

  • December 5, 2008 at 1:23 am

    #203786

    I have the below code which is called in Excel.

    How can I chabge it to prompt the user to enter a date?

    select value_date,

    prsg_date,

    record_type,

    ext_infc_stus,

    ext_err_num,

    allgd_ref,

    purc_sale_ind,

    cpty_code,

    inst_code,

    nom_qty,

    net_consid_amt,

    sett_curr_code,

    our_dlvr_acnt,

    our_rcpt_acnt,

    source_acnt,

    other_ref

    from alleged_trade algd

    where algd.sett_mech_code = 'AOT'

    and trunc(algd.prsg_date) = '27-NOV-2008' --Assume AOTP ran yesterday

    and algd.prsg_bus_date = '27-NOV-2008'--Assume AOTP ran yesterday

    and not exists (

    select tint.infc_tag

    from trade_interface tint

    where tint.infc_tag = algd.allgd_ref

    )

    Thanks

  • December 5, 2008 at 2:16 am

    #908107

    Which version of excel??

  • December 5, 2008 at 3:11 am

    #908121

    Excel 2003 SP2

  • December 5, 2008 at 3:47 am

    #908133

    Even If i could create a Macro button which when clicked prompts the user....

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply