can you create a calculated field in a table?

[mrbeepa]

I am trying to get a column to display a user defined paylevel. (I tried to think of how to make this a seperate table but not sure) if a sales person sold 1 - 3 contracts pay level would = 1; 4 - 7 pay level would = 2 and 8 + pay level would = 3. I want a table column to display the pay level number for any given pay week so it can be accessed later to figure bonuses pay adjustments and etc. Trouble is I don't see where I can enter a formula in a data column in design view, was trying to use default view but I don't seem to be able to access any form of an IF statement, using the expression builder. I set up a query that calculates the number of sales in a given week but I don't know how to get that to automatically run when the table is access nor how to get it to determine a lvl like 1,2 or 3 so far it just counts the sales. (but I think it's just monday brain on weekend time for that part!!)Hope this isn't too discombobulated! Thank you for any assistance,

 

[namliam]

You dont, calculated values should be just that... calculated when needed.

 

[mrbeepa]

thank you

You dont, calculated values should be just that... calculated when needed.

Thanks again CDrake I was kind of thinking that was going to be the answer! Just wasn't sure. I got a few ideas from someone about using a switch in a query to do what I was trying to do. I think that's going to work.

Thank you again for your response,