Hello Team
I have designed a power plant production database in MS Access, as of now its running smoothly even after 2 years.
Database is mostly doing maths for different task. Efficiency correction, Stock calculations with ASTM equations, and hourly calculation based on plant load, to speed up I am using custom functions in VBA but still I feel database is slowing down.
My question is that should I do calculations in forms and upload data to table or let it be in queries.
My hourly query has more than 40 calculated fields.
I have designed a power plant production database in MS Access, as of now its running smoothly even after 2 years.
Database is mostly doing maths for different task. Efficiency correction, Stock calculations with ASTM equations, and hourly calculation based on plant load, to speed up I am using custom functions in VBA but still I feel database is slowing down.
My question is that should I do calculations in forms and upload data to table or let it be in queries.
My hourly query has more than 40 calculated fields.