Results 1 to 3 of 3
  1. 06-30-2024, 11:55 PM #1
    Alex Motilal
    Alex Motilal is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Nov 2008
    Location
    Coimbatore, India
    Posts
    193

    DSum Function


    DSum function returns the result of numeric values as Text, aligned to left. How to solve this?
    Reply With Quote Reply With Quote
  2. 07-01-2024, 12:04 AM #2
    June7's Avatar
    June7
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    Try wrapping in Val() function.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
    Reply With Quote Reply With Quote
  3. 07-01-2024, 01:43 AM #3
    Welshgasman
    Welshgasman is offline VIP
    Windows 11 Access 2019
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,556
    Click image for larger version.  Name: dsum.png  Views: 15  Size: 8.1 KB  ID: 51925
    Quote Originally Posted by Alex Motilal View Post
    DSum function returns the result of numeric values as Text, aligned to left. How to solve this?
    Where is that happening?
    I have a Dsum() for this control and it is set as General, yet shows as on the right? plus I can multiply that value and I do not get a Type Mismatch?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Using the DSum Function for the first time
    By Jessica240 in forum Reports
    Replies: 7
    Last Post: 01-23-2015, 03:06 PM
  2. Dsum Function
    By LOIZOS in forum Forms
    Replies: 10
    Last Post: 03-20-2014, 10:05 AM
  3. DSum Function
    By azhar2006 in forum Forms
    Replies: 7
    Last Post: 12-08-2013, 05:07 PM
  4. Dsum() Function
    By rkalapura in forum Queries
    Replies: 2
    Last Post: 10-24-2012, 05:58 PM
  5. Dsum() function
    By rkalapura in forum Forms
    Replies: 3
    Last Post: 10-10-2012, 10:06 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums