formula mini question 1

[doorbreaker]

hi,

i am using the following formula to make an sql update statement in excel:

="update tablename set weight = '"&B2&"',name='"&C2&"',other='"&D2&"' where pk = "&A2

how do i add a comma ( at the end? It errors if i try.

Thanks

Chris

 

[PHV]

This raises an error ?
="update tablename set weight = '"&B2&"',name='"&C2&"',other='"&D2&"' where pk = "&A2 & ";"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[doorbreaker]

thanks