Access 2010 calculated table field

[Moss100]

Hello,

In my database I would like to add a calculated field at table level so it is consistent throughout the database.

I have a field [startdate] and I would like an end date a year later.

Access 2010 will not let me use the dateadd function in the tables calculated field.

I understand I can use it in a query based on the table - but it would be handy to have it at table level.

I can use [start_date]+365 and that works, but of course will not be quite accurate.

Any ideas?

Thanks Mark

 

[PHV]

Why store derived/calculated value in the table ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[Andrzejek]

I am with PHV - don't do that in a table.
If you really want to - create yourself a query based on your table and calculate it in the query.

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

 

[kjv1611]

I realize this is a bit late, but just now seeing it.

If you're showing it in a form, and you want to use a query or a calculated form field, then you could look at using DATEADD/DATEDIFF functions to get to whatever specific type of date you want to get to. Those 2 create a mean combination in SQL Server, and I think Access as well last I checked.

"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57