Access-Query needed for removal text within field

I need a query to remove text within fields from my table in access. It should be fairly simple for a more access experienced person. I have enclosed a sample database. I need the queryo remove every text until the $ (including the removal of $) in the textfield. It's also ok if it's a series of queries that is turned into a single macro. See the enclosed database for details ## Deliverables The enclosed database enhanced with the query/macro that takes out the specified text within the fields in the table ## Platform WindowsXP, Microsoft Access 2003