Industriallust
New member
- Local time
- Today, 10:12
- Joined
- Sep 2, 2008
- Messages
- 3
I'm relatively new to Access 2000 Professional and I'm having some trouble understanding how to set up a calculation for a field when the 1 number I need to perform that calculation is coming from a particular cell of a related table. Basically, I need to know how to write a mathematical expression (add, subtract, divide, or multiply) for an entire field of cells when the 1 number I need to perform this calculation is coming from 1 cell of a related table. Can someone help me with some examples? Also, where would I place this expression? In the many individual field cells themselves or somewhere within the Field Properties General tab for the field I need these calculations in? Thanks!