Forum Replies Created

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

  • RE: Help: Calculated CASE Statement in Query

    It's basically the same isn't it? For the most part? SQL code is recognized by Microsoft Access. Anyway, I'm just trying to sort this out. We don't...

  • RE: Help: Calculated CASE Statement in Query

    Thanks. I changed it to the code below and it gave me a syntax error "missing operator in query expression".

    TITLE.MilSrchPerfrmed,

    TITLE.AttySigned,

    TITLE.CompltDrafted,

    TITLE.Compltverrecd,

    TITLE.Compltversent,

    TITLE.ExamStarted,

    TITLE.ExamComplete,

    TITLE.brchltrwaived,

    TITLE.brchltrreccorr,

    TITLE.TitleRptOrdd,

    TITLE.TitleRptRecd,

    ODOC.LNARecd,

    ODOC.OrigNoteRecd,

    ODOC.ChainofTitleCorrect,

    ODOC.ChainofTitleIncorrect,

    ODOC.ChainofTitle,

    ODOC.NoteCertExec,

    CASE When TITLE.MilSrchPerfrmed is null...

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