Look for possible match field

B

Bill

Hi,

Currently, I have one column in the database. I create a brand new list
of dropdownmenu with three different columns.
I am cleaning up in the old database and find one column in the database to
look up and find a match on Column #2 only and not Column #3 and #4. If
it's match to column #1 and Column #2 and then update in my new three
columns from my dropdownmenu into my table.

for example


Current Database:
Column #1: "Seafood <<Pasta>> with Sauce"


New Database:
DropDownMenu has three columns:
Column #2: << Pasta >>
Column #3: Seafood
Column #4: Sauce

I try to use but not sure how to update into the table :

[Column #1] like *Pasta*,[Column #2] on query but trying to update the table
instead of query

Your help would be much appreciated.
Thanks
 

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

List all tables, including document structure 0
Remove Identical words 0
Query the same table three times 0
Merging from an Excel file with graphics 1
Insert Index into a Table 1
Arriving at totals 2
Strange behavior with InfoPath and repeating rows 0
Matching data in columns 1

Top