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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA - retrieve data on last create named range from previous inserted named range 0
Access #Error & Excel Pivot 0
Expression in Access table 3
How to export table from outlook into ms access table? 0
How to Populate Data from a table to another 0
Payroll database needed 3
Access Query problem 1
writing expressions? 6

Back
Top