Bypass the no edit restrictionin "Total queries"

[fugifox]

I have a form for displaying the Club Members info (like Name, Address etc).
I'd like on the top right of the total debit of each Member to be displayed.
For that reason I construct a Total query.
Problem is that when I'm trying to relate the MemberInfo form with this query,
all my records are locked due to the restriction that forces a Group By query.

Since in my case the info provided by this query is eitherway only for read puposes (just displaying the Balance) can you suggest me a trick or something to bypass the Access restriction concerning the Group By queries?

Thank you in advance

 

[KeithG]

Use the DSum function to calculate the total debits. You can set the criteria so it show the current club members total debits.