Page 2 of 2 FirstFirst 12
Results 16 to 17 of 17
  1. #16
    kiranair is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2016
    Posts
    53
    yes am getting my answer i used Manual: Nz([manu].[Man])+Nz([manu1].[Man1])



    I got it !!!!!!

    Thankfully, Microsoft Access offers a way around this issue in VBA module code
    or queries. The NullToZero function (NZ) takes a null value and converts it to
    zero. You should use this function anywhere a value could be null (like a field
    that is not required).


    since in my case after join operation their were null values so it was giving me the answer null

    Thanks a lot for your precious time ajax!!!!!

  2. #17
    kiranair is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2016
    Posts
    53
    Ajax ,

    Another question , If I want to roundup a number Eg 6.2 Round() ll make it as 6. But I want to customize it Eg I want a no to roundup 0.2 to 0 and 0.21 to 1,3.11 to 3 and 3.33 to 4 ,How can I make it????

Page 2 of 2 FirstFirst 12
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 03-05-2015, 02:28 PM
  2. Replies: 3
    Last Post: 06-30-2014, 12:53 AM
  3. Left Join Query Issue - MS Access
    By mkc80 in forum Queries
    Replies: 1
    Last Post: 08-07-2013, 04:17 PM
  4. Replies: 7
    Last Post: 09-06-2012, 06:04 AM
  5. Replies: 3
    Last Post: 02-02-2011, 01:00 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