Results 1 to 2 of 2
  1. #1
    David Randle is offline Novice
    Windows 10 Access 2016
    Join Date
    Mar 2016
    Posts
    6

    Dsum Error when printing report


    Hi

    I have a report that uses a number of Dsum calculations.

    While they show the correct result on the screen they covert to #error messages in both print preview and print options.

    In fact they convert to errors if I scroll down the report using the scroll bar.

    Would appreciate some assistance with this.

    Many thanks

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    how can we help with no information about what your dsum is called, how it is constructed, details of your report and recordsource?

    Also not clear what you mean by 'correct result on screen'

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

Similar Threads

  1. Replies: 11
    Last Post: 06-24-2015, 01:36 PM
  2. DSum Error
    By alsoto in forum Queries
    Replies: 4
    Last Post: 11-21-2011, 10:47 AM
  3. DSUM() Error
    By msr71 in forum Access
    Replies: 14
    Last Post: 09-25-2011, 06:39 PM
  4. Printing Error:Prints form instead of report
    By jordanturner in forum Access
    Replies: 1
    Last Post: 12-08-2010, 04:42 AM
  5. Report Printing Error
    By gjohnson71 in forum Reports
    Replies: 4
    Last Post: 03-07-2009, 12:36 PM

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