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]
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]