Find and replace using wildcard in MS Access

[Bubbler]

I am sorry if this seems basic to all of you but I am at my wits end, I have an access db and a fld contains entries like this:

This is the first record (more info1)
This is second first record (more info2)

I am trying to use the find replace with a wildcard so that it would become:

This is the first record
This is second first record

All I am trying to ghet it to do is remove everything between brackets as well as the brackets themselves.

I have tried for over an hour with no results. This is just a text fld in an access db, nothing special.

 

[bkpchs237]

Bubbler,
If you want to remove everything after the first parentheses, then run a query with the following:
Left([Fieldname],InStr(1,[Fieldname],"(")-2)

After that you could either run a make-table query with this new field as one of the items, or run an update query using the formula above to replace the items as needed, once you are sure the resulting values are what you desire.

Hope this helps.