Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Posts
    37

    Unanswered: Oracle to Access query

    Can someone tell me how to convert this query so that it may be used in MS Access...I don't know how to convert the first 2 statments so they will work in MS Access.
    NVL(sum(a.amt_owe_tot_cur_sup), 0) AS [Suport Owed],
    NVL(sum(a.amt_app_tot_cur_sup), 0) AS [Support Paid],

    SELECT
    NVL(sum(a.amt_owe_tot_cur_sup), 0) AS [Suport Owed],
    NVL(sum(a.amt_app_tot_cur_sup), 0) AS [Support Paid],
    C.IV_D_DO_CODE,
    C.WORKER_ID,
    A.ID_CASE,
    A.MTH_SUPPORT

    FROM NOLDBA_LOG_SUPPORT A INNER JOIN NOLDBA_INT_CASE_STATUS C ON A.ID_CASE = C.CASE_ID

    WHERE (((C.IV_D_DO_CODE)=[00]) AND ((C.WORKER_ID)=[00000]) AND ((A.MTH_SUPPORT)=[YYYYMM]))
    AND a.seq_event_global =
    (SELECT MAX (b.seq_event_global)
    FROM NOLDBA_LOG_SUPPORT b
    WHERE b.id_case = a.id_case
    AND b.seq_order = a.seq_order
    AND b.seq_obligation = a.seq_obligation
    AND b.mth_support = a.mth_support)
    GROUP BY
    C.IV_D_DO_CODE,
    C.WORKER_ID,
    A.ID_CASE,
    A.MTH_SUPPORT

  2. #2
    Join Date
    Sep 2003
    Location
    The extremely Royal borough of Kensington, London
    Posts
    778
    Select IIF(ISNULL(column) = TRUE, nullValue, column)

    where nullValue is the value to return if the column is null.
    Bessie Braddock: Winston, you are drunk!
    Churchill: And Madam, you are ugly. And tomorrow, I'll be sober, and you will still be ugly.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •