• select Date    ,Amount,    Location,    [Posted Date],    [Posted Amount],    Camount,Status
    from Tablename
    where status ='posted'

    ***The first step is always the hardest *******