One table has a sum that I want to display into a form not of that table if that makes sense. I'm using this which errors out:
=Sum([tbl_Commission].[Commissions])
also used:
=DLookUp(=Sum([tbl_Commission].[Commissions]))
Again, trying to display a total SUM from a form into another form.