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)