You need an update query. First make a backup of the table or, better yet,
the entire database just in case somethig goes bad.
Create a select query that includes the field needing to be marked up. Run
the query and make sure that you have only the records that you need. If not,
you'll need to modify the criteria for the Products field to get only the
correct records.
After you have the select working correctly go to design view of the query.
On the toolbar select Query, Update Query.
In the Update To row under the column needing update put something like so:
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
