Hi all,
I've tried searching for this problem (this site and Google), but I haven't found an answer yet.
I have a query that was working fine until today.
In the Field area of the QBE grid I have:
Total Current: Sum([earned_current]+[unearned_current])
The query is grouped and I have the Total line set to Expression.
The error I'm getting is: Subqueries cannot be used in the expression ([earned_current]+[unearned_current]).
Does anyone know why I'm suddenly getting this error? It's driving me to drink!
Thanks.
I've tried searching for this problem (this site and Google), but I haven't found an answer yet.
I have a query that was working fine until today.
In the Field area of the QBE grid I have:
Total Current: Sum([earned_current]+[unearned_current])
The query is grouped and I have the Total line set to Expression.
The error I'm getting is: Subqueries cannot be used in the expression ([earned_current]+[unearned_current]).
Does anyone know why I'm suddenly getting this error? It's driving me to drink!
Thanks.