Divide one figure from another

[Jaharul]

This is the SQL from a Access project. What i am trying to do is divide the AMOUNT by the RATE as an expression but it don't seem to be working. Please help me.

FROM dbo.SALFLDGALL INNER JOIN
dbo.SSRFACC ON dbo.SALFLDGALL.ACCNT_CODE = dbo.SSRFACC.ACCNT_CODE INNER JOIN
dbo.SSRFCNV ON dbo.SALFLDGALL.PERIOD = dbo.SSRFCNV.PERIOD
WHERE (dbo.SSRFACC.SUN_DB = 'ALL') AND (dbo.SSRFCNV.CODE = 'GBP')
GROUP BY dbo.SALFLDGALL.ACCNT_CODE, dbo.SALFLDGALL.PERIOD, dbo.SALFLDGALL.JRNAL_NO, dbo.SALFLDGALL.AMOUNT, dbo.SALFLDGALL.DESCRIPTN,
dbo.SALFLDGALL.OTHER_AMT, dbo.SALFLDGALL.ANAL_T1, dbo.SALFLDGALL.ANAL_T2, dbo.SALFLDGALL.ANAL_T0, dbo.SSRFACC.ACCNT_NAME,
dbo.SALFLDGALL.TREFERENCE, dbo.SALFLDGALL.ANAL_T4, dbo.SALFLDGALL.ALLOCATION, dbo.SSRFCNV.RATE
HAVING (dbo.SALFLDGALL.ACCNT_CODE BETWEEN '60000' AND '69999') AND (dbo.SALFLDGALL.ANAL_T4 = 'COMSEN') AND
(dbo.SALFLDGALL.ALLOCATION <> 'C')

 

[SydneyGeek]

Hi Jaharul,

where's the SELECT statement? That's where I'd expect to see the division happening -- can't comment without that info...

Denis