Results 1 to 5 of 5
  1. #1
    Mehvan's Avatar
    Mehvan is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2016
    Posts
    133

    Post I have a problem with function Nz in Query

    Hello everyone
    I have a problem with function NZ in Query if someone can help me about it , I will be so pleased
    I have 4 queries


    ( buy invoice , sale invoice , customers Return and To products return )
    this is my Table for all
    I made this for all 4 invoice in Query :
    Click image for larger version. 

Name:	Capture.PNG 
Views:	19 
Size:	20.7 KB 
ID:	26129
    and after that I used Nz for two tables ( buy invoice and customers return ) because both are add in inventory
    and I made for ( sale invoice and products return ,,, I mean I return something to the products ) in another query
    Click image for larger version. 

Name:	1.PNG 
Views:	20 
Size:	52.5 KB 
ID:	26130
    and for Quantity I made the same and also for sale invoice too
    but I don't know why it isn't appear
    and after that I made special query for ( total buy and total sale )
    I want when I enter data in buy invoice automatically it enter zero in other , even my inventory appear

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Put NZ in the query behind the form on each field needed. Then you don't need it elsewhere.

  3. #3
    Mehvan's Avatar
    Mehvan is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2016
    Posts
    133
    I already used in Query for every field I need it , I used for
    But I don't know Why doesn't appear , even I made relationship to all tables I need to have a relationship .

    Do you can explain to me more ,, If don't be disturb to you , please ?

  4. #4
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    You DON'T need a relationship in Q1. This will be only the 1 table with all fields corrected with NZ.
    this will clean up the values.

    then Q2 will use Q1 and other tables in the relationship.

  5. #5
    Mehvan's Avatar
    Mehvan is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2016
    Posts
    133
    thanks a lot

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

Similar Threads

  1. The problem with the function sum()
    By end in forum Access
    Replies: 2
    Last Post: 01-31-2016, 03:41 PM
  2. Problem with function?
    By devxweb in forum Access
    Replies: 2
    Last Post: 01-07-2013, 08:43 AM
  3. Problem in Query and DSUM function
    By simplefahad2005 in forum Access
    Replies: 3
    Last Post: 07-27-2012, 12:46 AM
  4. Problem with IIF function
    By Hulk in forum Forms
    Replies: 3
    Last Post: 03-20-2011, 12:59 PM
  5. VBA Function problem
    By smikkelsen in forum Programming
    Replies: 5
    Last Post: 07-16-2010, 07:46 AM

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