expression in tables

  • Thread starter Thread starter boz
  • Start date Start date
B

boz

I am having trouble building an expression in my table to calculate 2 columns
in my table; can anyone help me with that.
 
Don't.

You shouldn't store calculated data in a table. It's a waste of storage space
and defies normalisation. Read up on normalisation, it's not just for
advanced users as i used to think.

You should calculate this data only when you want to display it, eg in a
report, on a form or in a query. If you end up using this calculation alot,
it might be worth learning how to write a VBA function to do it. Then you'd
only have to call the function each time you wanted to run the calculation.
 
Can't be done. It's a database; not a spreadsheet.

You need to do it in a query. Tables should just store data. Queries, forms,
and reports can be used to manipulate the display of such data.
 
Back
Top