I don't see why this should be contradictory. The fact is the calculated
column is not "stored" in a Query, so the cases are not even similar. By
the same reasoning, we should never store a Join of two tables because that
would produce data redundancy.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L


"Jamie Collins" wrote in message
oups.com...
On 15 Aug, 22:05, fredg wrote:
If you saved your query with the calculated column as a stored Query
(Title Case) object then this would become a virtual table. You would
seem to be saying that denormalization in a base table is wrong but
fine in a virtual table. That sounds contradictory.