In the best situations, calculated fields have very limited usefulness. The calculation has to be straight SQL. It cannot involve VBA at all. It also can only use hard-coded values or values from other fields in the current record. I believe the only plus is that they can be indexed so if...