Easy question

Probably an easy question. Im very used to using SQL but have no idea how to do this in access.

I have a table that contains conversion rates for currencies. I also have a select statement. The select statement pulls out some values that need to be converted to a specific currency. So lets say they come out in USD I want them in AUD.
This is my code showing how I am doing it currently. It works but is slow. There must be a better way of doing it.

Code:

---

SELECT
[a].ACCGRPID
, [a].ACCGRPNAME
, [a].PERIL
, Sum([SumOfVALUEAMT]/[dbo_currfx]![XFACTOR])*(SELECT [dbo_currfx]![XFACTOR] FROM dbo_currfx WHERE CODE = 'AUD') AS VALUEAMT_AUD
FROM
a
LEFT JOIN
dbo_currfx ON [a].VALUECUR = dbo_currfx.CODE
GROUP BY
[a].ACCGRPID
, [a].ACCGRPNAME
, [a].PERIL;

---

Thanks in advance

Easy question