Access- Query Question

[CodeMonkeyDb]

I have a database where I create an Address field by concatenating several fields. The problem is, a double space is often added into the address. On small recordsets, I've been just using the find/replace function to replace a double space with a single space. However, I now have a couple tables that contain over 200K records. I've been racking my brain over how to write a query to do the same as the find replace without deleting the actual address data, but my attempts thus far have failed.
Can anyone help? I have the feeling this should be really easy, but it's my first week back to work from being on leave for a few months and my brain is still rusty!

TIA!

-Justine

[schroederwallac]

Here you go - this is a query to update that field.

UPDATE tblDownload SET tblDownload.Address = Replace([Address]," "," ",1)
WHERE (((tbl.Address) Like "* *"));