Results 1 to 3 of 3
  1. #1
    Tuckejam is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2020
    Posts
    168

    Still can't add

    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

    Click image for larger version. 

Name:	Capture.PNG 
Views:	16 
Size:	16.3 KB 
ID:	45781

  2. #2
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    So what happens? Error, incorrect result, nothing?
    Try entering the full expressions for each part in the final textbox.
    If that fails, try wrapping each in Nz(...,0)
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  3. #3
    Tuckejam is offline Competent Performer
    Windows 10 Access 2010 64bit
    Join Date
    Jan 2020
    Posts
    168
    well...... it works now.......... that's annoying

    I tried several thing and then the first time I tried the formula in the picture, the entire report came back blank so I decided to ask for help.
    thinking now that I must have had the form it looks at in design view.

    anyway, thanks for the help

Please reply to this thread with any new information or opinions.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums