Updating Single Field Multiple Times

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list of 1000's of products that I would like to categorize based on
their names. I expect to have about 50 categories and prefer not to have 50
different update queries.

What I have now is:
Product Description | Product Category

If the product description contains SMTP, I'd like the Product Category to
be SMTP
If the product description contains Groupware, I'd like the Product Category
to be Groupware
etc... perhaps another 50

Is there a way to do this in a single update query?

Many thanks for your help!

Minh
 
Yes. You will need to build a translation table that has the description
information and the Category.
Product Description | Product Category
SMTP SMTP
Groupware Groupware
Bilko SGT
Halftrack General

Then in the Update To section of the query grid put
[YourTranslationTable].[Product Category].
In the criteria of your [MainTable].[Product Description] field put Like "*"
& [YourTranslationTable].[Product Description] &"*"
 

Ask a Question

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.

Ask a Question

Similar Threads

VBA: How can I use a string variable as autofilter criteria? 4
Fill in multiple fields with one lookup 0
ConcatRelated 0
Availability between dates 4
New to Access, need some help with a query 1
Update or append query? 2
Return a data from a table that doesn't have a relationship 3
Combo boxes and products with multiple categories 5

Back
Top