Still Confused

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm still confused. Perhaps including the query will help:

UPDATE Client1 INNER JOIN PARHSTY1TEMP ON
Client1.CLIENTNO=PARHSTY1TEMP.Clientno SET
Client1.Partici=Client1.Partici+PARHSTYTEMP.AMOUNT

My problem is that Client1.CLIENTNO is TEXT while PARHSTY1TEMP.CLIENTNO is
NUMBER.

What needs to be added to this Query so that it will work?
 
In the SQL view, you should be able to Wrap Client1.ClientNo in the VAL
function and force it to be a number versus a string. You cannot do this in
the query grid, you have to do it in the SQL window.

This may not be an updatable query. Try it and see. IF you get an error
message, then post the error and the SQL you tried.

UPDATE Client1 INNER JOIN PARHSTY1TEMP ON
Val(Client1.CLIENTNO)=PARHSTY1TEMP.Clientno
SET Client1.Partici=Client1.Partici+PARHSTYTEMP.AMOUNT
 
Back
Top