Using the Where clause in an update query

S

shane

Code below was entered into the "Update To" field while writing a query in
design view (Wizard)...As a result the "...operand without and operator..."
dialogue box shows up. The intent is to update a number identification field
to:

"061-" & forms!main!line &"-"& equipmentlistings!numberset where
forms!main!equipment = equipmentlistings!equipmenttype &"-"& forms!main!method

Equipmenttype and Numberset are from the same table, equipmentlisting, all
stored as text. Equipmenttype is chosen from a form.

I've tried a few things reading thru the help files with no luck. Thanks in
advanced.
 

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

Update Query in VBA 3
Running Update Query in VBA fails 5
Newbie Update Query Question? 4
Problem With Parameters in Cross Tab Query 0
Expression in SQL or user-defined function? 4
update a field in a table 1
Dates in where clause 5
Update Query: Parameters = Date & Text Field on Form 1

Top