Making four queries into one

  • Thread starter Thread starter guidop12
  • Start date Start date
G

guidop12

I have the following four queries that I run separately. My question is,is
there a way to put all four queries into one.

Query One (Update Query)
Field: City Field: State
Table: TableName Table:TableName
Update: SplitFields_part1([citylabel),â€,â€) Update:
Splitfields_part2([citylabel])


Query Two (Update Query) To strip Spaces in State Field
Field: State
Table: TableName
Update: Stripspaces([state])

Query Three (Update Query) To strip Zip from State
Field: Zip
Table: TableName
Update: Trim(Right([state],len([state])-instr([state],†“)))

Query Four(Update Query) To strip zip from state after putting zip in own
field
Field: State
Table: Tablename
Update: left([state],3)


Thanks
 
I have the following four queries that I run separately. My question is,is
there a way to put all four queries into one.

Query One (Update Query)
Field: City Field: State
Table: TableName Table:TableName
Update: SplitFields_part1([citylabel),”,”) Update:
Splitfields_part2([citylabel])


Query Two (Update Query) To strip Spaces in State Field
Field: State
Table: TableName
Update: Stripspaces([state])

Query Three (Update Query) To strip Zip from State
Field: Zip
Table: TableName
Update: Trim(Right([state],len([state])-instr([state],” “)))

Query Four(Update Query) To strip zip from state after putting zip in own
field
Field: State
Table: Tablename
Update: left([state],3)


Thanks
Click to expand...

Rather than posting a picture of the query grid, it's much simpler to convey
the nature of your query by selecting View... SQL and posting the SQL text
here.

Yes, you can update multiple fields in one Query. I'm not certain of the
structure or the contents of the data or the operation of your functions so I
hesitate to write sample SQL, but you should be able to do all of these in one
query - just put your current Update: expressions under all four fields.
 
Back
Top