Forum Discussion
Replicating an Excel formula in Access?
I'm trying to import some Excel data into Access. I have one column in my Excel spreadsheet that performs a calculation on two date cells. For example: Excel cell D1 has a date value, for this ...
You can create a new, calculated field in an Access table. The expression would be different, of course.
That said, we discourage calculated fields in relational database application tables. They belong in queries or controls on forms or reports, not in tables.
In Excel you have no choice. Everything is in one flat interface--the worksheet.
Access is not subject to that limitation and the interface offers much richer alternatives. Therefore, don't think about storing the calculation as part of the data. Think about DISPLAYING it, only when needed, in a form or report.