Hello everyone!
I have a few questions regarding an Access 2007 DB that I am developing. I am wondering if these are possible in Access 2007 or if I need to use something else.
I need to add a field in one of my tables that will calculate between fields in the table. I need this to be dependent on a status field, since the calculation may change.
psuedo code:
if(table.field = fixed)
Calculated_Field = Fixed_Cost
if(table.field = indexed)
Calculated_Field = Fixed_Cost + Index
etc..
I noticed 2010 has the calculated field option in the table design, but 2007 doesnt. Also, I know you can do calculations in queries but this needs to be in the table since there are different calculations based on status.
Thanks a lot!