Hi,
I have a table with 3 end Columns (Qty, Weight and total) the total is calculated with the following SQL :
UPDATE tblWarehouse_stock SET Total = (Qty*Weight);
The problem is that these days it is possible to have the word "Part" replace the weight number value. Obviously this is causing problems. Is there a way in SQL to say if weight value is non-numberic then exit code? or does this have to be done via VBA? thanks a lot in advance.
Sean.
I have a table with 3 end Columns (Qty, Weight and total) the total is calculated with the following SQL :
UPDATE tblWarehouse_stock SET Total = (Qty*Weight);
The problem is that these days it is possible to have the word "Part" replace the weight number value. Obviously this is causing problems. Is there a way in SQL to say if weight value is non-numberic then exit code? or does this have to be done via VBA? thanks a lot in advance.
Sean.