I have a table called tblAccountTransactions. In this table are the fields BankedAmnt and AccntNo.
In the query grid window in the first column is AccntNo. In the second column is the formula total: DSum(BankedAmount,[tblAccountTransactions]).
However when I run the query it is asking for a parameter value for tblAccountTransactions ...why?
BankedAmnt is what I want to total and the domain is tblAccountTransactions.
What am I doing wrong? thanks
In the query grid window in the first column is AccntNo. In the second column is the formula total: DSum(BankedAmount,[tblAccountTransactions]).
However when I run the query it is asking for a parameter value for tblAccountTransactions ...why?
BankedAmnt is what I want to total and the domain is tblAccountTransactions.
What am I doing wrong? thanks