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.
 
O

orange

Joined
Dec 17, 2007
Messages
57
Reaction score
0
shane said:
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.
Click to expand...

In overview, what are you trying to do? And where does the Form come into play when you're writing the query in design view?
 

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

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

Top