I would like to fill in a text box on a form with a query of something like this. It will keep a tally of the data filled in with the records on the page. I will have the tally refreshes after a record is updated or added within the form.
SELECT DISTINCTROW Sum([tblTABLE].[COLUMN]) AS [Sum Of COLUMN]
I have this query working in a query. But I wanted the form to perform a query such as this but limit the sum math to the records that match the ID from a part of the form.
I got this to work as well but this adds all columns in the table, again I only want a sum of records that match a criteria (ID from a place on the form). =Sum([tblTABLE]![COLUMN])
Help please! Thank you