Kim:

It's been quite a while since I did something like this in QUERY. IIRC 
you have to do it in 2 passes. The first is to read the data and format 
a script that has the update values. Then run that script to do the update.

As I haven't used QUERY syntax in years, so I know I would screw up an 
example, but the report phase would have to write the find and update as 
well as the execute statement over and over. One for each update.

Yeah it's been a while but I know it can be done.

HTH

Dave


Kim Borgman wrote:
> Playing with query again.
>
>  
>
> I thought there was a way to replace a field in a data set with the value in
> an existing field.
>
>  
>
> In this case, I need salesman(6) to go into salesman(7).
>
>  
>
> Tried update, replace salesman(7)=salesman(6);end 
>
>  
>
> Choked big time.....it's looking for literal value where salesman(6) is....
>
>  
>
> Suggestions ?
>
>
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
>
>   

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *