Perhaps this ?
=DLookUp("[SumOfLoan Value]","TotalsFilter","[Loan Status]=5")
Thanks PHV, but unfortunately I'm still getting the exact same error. :-(
Hi all,
I've been looking fruitlessly on the net for a while and can't really find a solution to my error.
I'm creating a database for home loans and want to show in the individual staff forms the total values for each stage that loans are at.
Related tables and queries in this scenario are...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.