(VBA) SQl add a calculated field

[sambrierley]

Hi all.

im defining the below string to be used in an execute command from Project to add a calculated field to a table.

Job Number is a variable (1086) and is the name of the table.
the error im getting is "Syntax error in field definition" and seems to be related to the Duration field (the one i am creating.)

any help would be grand thanks

AddDuration = "ALTER TABLE " & JobNumber & " ADD Duration AS ((Finish '-' Start)*2.66666666666667);"

 

[Ranman256]

IF you have the math inside the quotes (shown above) then it wont run, the math must be outside:
= "ALTER TABLE " & JobNumber & " ADD Duration AS " & (([Finish] & - [Start])*2.66666666666667)

 

[sneuberg]

The post in this site http://stackoverflow.com/questions/31621363/how-to-add-a-calculated-column-to-access-via-sql says you cannot do that through SQL and gives some code by which you can do it.