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