inserting data in MS access database w/ calculated field

[LB]

Hello all; 

So I am trying to insert data into a MS Access database that has a calculated field (field1/field3) in it- 

but I am not sure from the SAS component how to structure the data per se for upload

i.e. as a binary, it can be 0 as fieldx or 1 as fieldx 

but this field is calculated by two others that I would like Access to do the calculations for me.

Also not all observations have values. 

I can always delete the field and upload the data myself but as it requires an update query I am trying to work around it not to require additional processing time where Access can do the work already.  

Thanks

Lawrence

[LinusH · Accepted solution]

Calculated fields fits best in views. And then you should be able to update the underlying table.

[LB]

Thanks! 

Lawrence