I am pulling the data from a view i wrote in sql server.
here is what the data looks like. i can't figure out how
to suppress the jobname in my view.
016011    CHARGE NURSE    ARNOLD    ELIZABETH DIANE
016011    CHARGE NURSE    BURROWS    JOANNA
016011    CLINICAL DIRECTOR    MILLER    JANA C.
016011    HUC (NON-CERT)    DANIELS    CARLA K.
016011    LVN    EZELL    CAROLYN JOANN
The user picks the dept from my list box
then the jobname  last name and first name appear.
but the jobname is still duplicated all the way down.