N newbie4access Registered User. Local time Today, 04:06 Joined Apr 23, 2015 Messages 25 Jun 10, 2015 #1 Hello I use access 2010. I am assuming by the error code, one can not use a calculated field to calculate another field. Clarification would help. Thanks n advance. Attachments 2015-06-10_1020.png 34.1 KB · Views: 207
Hello I use access 2010. I am assuming by the error code, one can not use a calculated field to calculate another field. Clarification would help. Thanks n advance.
C CJ_London Super Moderator Staff member Local time Today, 10:06 Joined Feb 19, 2013 Messages 17,496 Jun 10, 2015 #2 correct - personally I would not use calculated fields, just calculate them when you need them. Users should not be looking directly at a table but via a form or report. They can't be indexed so any searches/sorts will be slow.
correct - personally I would not use calculated fields, just calculate them when you need them. Users should not be looking directly at a table but via a form or report. They can't be indexed so any searches/sorts will be slow.
