[Solved] Form SQL Error
Posted: Sun Jun 03, 2018 5:30 am
A couple of Errors occured.When adding a SUM nested query to the buydca.odb Invoice & Details form, it initially worked,then broke the Form.
I'm trying to do a nested query of the subform InvoiceDetails & Total Price query, to calculate a Sum Total from the item's Total Price's The nested query only has one field, which is the Sum function of the Total Price field in the query (which links into the subform.) The Sum query was then tied to a Form numerical field, and initially worked. Then later on, reopening the db, it broke the Form, because the InvoiceID and associated Main Form fields no longer loaded/displayed. So i tried to delete the new field, and it's subquery -- this resulted in the problem, that when opening the Invoice & Details Form again, after saving, the db kept trying to access the subquery SQL, though it and the associated field has been deleted. (for clarity i recreated the nested subquery Sub Total for anyone interested in analyzing the bug).
I'm unable to find a menu option for viewing the Form subquery SQL , which should have been deleted when it and the associated field was deleted. Why when opening the Form, is it still trying to access the now deleted sub nested query ?
Trying too explain this is difficult when keeping the description as quick and simple as possible.
I'm trying to do a nested query of the subform InvoiceDetails & Total Price query, to calculate a Sum Total from the item's Total Price's The nested query only has one field, which is the Sum function of the Total Price field in the query (which links into the subform.) The Sum query was then tied to a Form numerical field, and initially worked. Then later on, reopening the db, it broke the Form, because the InvoiceID and associated Main Form fields no longer loaded/displayed. So i tried to delete the new field, and it's subquery -- this resulted in the problem, that when opening the Invoice & Details Form again, after saving, the db kept trying to access the subquery SQL, though it and the associated field has been deleted. (for clarity i recreated the nested subquery Sub Total for anyone interested in analyzing the bug).
I'm unable to find a menu option for viewing the Form subquery SQL , which should have been deleted when it and the associated field was deleted. Why when opening the Form, is it still trying to access the now deleted sub nested query ?
Trying too explain this is difficult when keeping the description as quick and simple as possible.