Unbound field in form to display summed field from a query

MediocreD

New member
Local time
Today, 18:57
Joined
Nov 9, 2024
Messages
4
I keep getting an error when I try to use a query to calculate the total profit for playing poker mtts

i made a calculated field in a query that correctly determined the sum of profit per MTT, but when I try to make the unbound field display the sum it says #Name?.

even though I used the expression builder so obviously the objects are there

this is what I type into unbound field so far...

=[qry_MTT_Profit_Sum]![SumOfMTT_Profit]
 
You can't just reference a query this way. If you want to retrieve a field from a query, use a domain function.

=dLookup("SumOfMTT_Profit", "qry_MTT_Profit_Sum")
 
thanks I swear I used to do it like this but I am probably mistaken it has been a few years...
 

Users who are viewing this thread

Back
Top Bottom