I’m trying to write a sum query through the event builder but I’m doing something wrong and not quite understanding it.
I have a table containing records; each record has a paid amount field. Each record is assigned a reference number which may be or may be not unique. IE some records have the same reference number.
What I’m trying to do is create a query that lists the total paid amount by reference number
I have created a query with the table, added a total paid amount field 'Sum([Grants - Master]![Paid Amount])' but get error message 'cannot have agrregate function...'
thanks for your help,