<p>I occasionally work on an old project that uses classic asp as a front end and an access database as a backend.</p>

<p>I'd like to create a new column in one of the tables that contains logic to calculate its value from the other columns in the row.</p>

<p>I know how to do this in a more modern DBMS, but I don't think that access supports it. Keep in mind I'm not using the access frontend, just the Jet DB engine via ODBC.</p>

<p>Any pointers?</p>

Can you just make a calculated column?
```
```
SELECT Table1.Col_1, Table1.Col_2, [Col_1]*[Col_2] AS Col_3
FROM Table1;
```
```