I have to say I spent several hours yesterday trouble shooting and fixing some pretty complex issues in Access and SQL server.
(and I am extremely grateful to this community for helping get to a place where I was capable of doing all that work)
and yet today I am toppled by simply trying to add some numbers in a report.
I have three numbers I need to add together (numbers generated from formulas)
Dues Owed =Sum([qry_ChapterDuesRPTQRY]![PastDue])
Fines Owed =Sum([qry_ChapterDuesRPTQRY]![PastDueFines])
Loans Owed =Nz(DLookUp("[TotalLoan]","[qryTotalLoanSelectedChapter]"),0)
Total Owed =?????????????????????????
if this helps, the first two are are pulling numbers out of the qry that this report is based on.
and the loans owed formula is obviously looking up a number from a different qry.
I have tried everything I (think) i know of and have looked through all of my other reports to see how those reports are totaling numbers but nothing I have tried will work.
Really though, thank you all for your help over the past 18 months