Search code examples
formsms-accessms-access-2007ms-access-2010

Access Calculated field in form or in table?

What's better for database consistence? A calculated field in a Form or in a Table?

e.g I have a Table which has some Date Fields! I want to calculate them so I can to update status.

[Start Date][End Date][Status]

I have a form to insert "Start Date" and "End Date"! So where is better to calculate it?

Thanks in advance!

Solution

  • Another option for you besides what HansUp has mentioned is to create a stored query that includes that expression as a value, then make the form based off that query. That way you have the advantage of accessing status AS IF it's a column in the table (although it will be read-only).