DateSerial in Query

[Guest]

I have used DateSerial in the control source in field in my table to
calculate the renewal date, adding 36 months to the original date, all works
great. When I run a query the renewal date is blank, the DateSerial hasn't
come over into that field in the query. I can't find any ControlSource in the
properties for the renewal field in the query.
All help will be appreciated.

 

[Van T. Dinh]

I am not sure what you described: A Field in the Table doesn't have
ControlSource.

My guess is that you referred to a Calculated Control (which has Control
Source) on a Form bound to your Table???

If this is the case, values displayed in Calculated Controls are *not* saved
into the Table, unlike bound Controls.

OTOH, calculated values should not be stored in the Table. Calculated
values should be re-calculated from other data whenever you need them. In
fact, the Relational Database Design Theory advises against storing
calculated values ...