Help with updating table field using query or form? (newbie)

[baronqueefington]

Good evening,

Firstly I am fairly new to access, I have a table holding clients data, I need it to work out the age of someone when an application is made, which I would like to be stored on said table

I have two fields [DOB] and [signed date], which I have used created a query with and an (unbooud?) field called age at application with the expression =DateDiff("yyyy",[DOB],[Date signed])

This works fine when I run the query, but I am unsure of the new next step of how to commit it to the table and even if that's possible.

Ideally I would like this to run behind a form maybe using some click event after the [signed date] field has been entered.



I currently don't know the best avenue to take, so would much appreciate it if someone could point me in the right direction.

[lfpm062010]

I would not recommend to store calculated value.
You can use the same calculate on the form.

[June7]

As lfpm stated, no need to save age into table, calculate when needed. Saving would require code (macro or VBA).

[baronqueefington]

Hello,

Thank you for your reply, I have read else where that recording calculated data is a bad idea, but I am still unsure why this is.

[June7]

Because raw data and the saved calculated data can become 'out of sync' and this is especially true with aggregate calcs. If raw data is edited then the saved calcs must be re-calculated and saved again. I know this doesn't really apply in your case - DOB is not likely to be changed. Still, the extra field in table and the effort to save data is just not necessary.

[baronqueefington]

Hello,

thank you for all of your replies, I have taken on board what you have said and will use a form to calc as and when.

Thanks.