Hi Guys,
what is faster? Calculated field within table (sum 2 of columns for example) or created new column using query?
What do you think?
Does it matter at all?
Jacek
Hi Guys,
what is faster? Calculated field within table (sum 2 of columns for example) or created new column using query?
What do you think?
Does it matter at all?
Jacek
never put calculated fields in a table
always calculate in a query
thank you ranman256.
Can you also explain why is this?
Best,
Jacek
query calculation are always live.
vs table : A field my not get updated then the value is wrong.
Hmmm thank you!
Jacek
Other considerations:
no other database engine (DBE) allows or supports Look up FIELDS in tables.
Look up FIELDS hide what is truly going on. See http://access.mvps.org/access/lookupfields.htm
hi ssanfu,
thank you.
I was asking about calculated fields, no look up fields.
Best,
Jacek
Head was in a different thread. Sorry...
Should always stay away from DLookup fields in tables, CALCULATED fields in tables and multi-values fields.
See Calculated Fields by Allen Browne