• Format A Calculated Column in a Query?

    From =?UTF-8?B?VHXDom4gTmd1eeG7hW4gQsOh?@21:1/5 to All on Thu Sep 10 19:42:38 2020
    SELECT mem.firstname, mem.lastname, pos.position, cam.campusname, (ROUND(pos.yearlymembershipfee / 12, 2)) AS Monthly_Dues
    FROM MEMBERS MEM, POSITION POS, CAMPUS CAM
    WHERE MEM.POSITIONID = POS.POSITIONID AND MEM.CAMPUSID = CAM.CAMPUSID
    ORDER BY cam.CampusName DESC, mem.LastName ASC;

    I tried with ROUND() and it worked :))

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)