Using the Where clause in an update query

  • Thread starter Thread starter shane
  • Start date Start date
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.
 
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?
 
Back
Top