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

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

Top