Simple backend table on mysql server: Bankbook (ID, date, IN, OUT) less than 2000 records.
Made a simple query in Access, with a selection for the date of the last record.
In a form based on that query, I calculate the balance (within the form: = SUM([IN]) - SUM([OUT]); the form takes 40 secs.
In a report based on the query, I calculate the balance (within the report); the report takes less than a sec.
Any idea what causes the form to be so slow
Made a simple query in Access, with a selection for the date of the last record.
In a form based on that query, I calculate the balance (within the form: = SUM([IN]) - SUM([OUT]); the form takes 40 secs.
In a report based on the query, I calculate the balance (within the report); the report takes less than a sec.
Any idea what causes the form to be so slow
