Results 1 to 2 of 2
  1. 11-28-2011, 03:53 PM #1
    kwooten
    kwooten is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jun 2011
    Posts
    255

    NZ Function on Sum Total


    I have a "hour" field that I am summing, in the query, for a report. There are quite a few null values that i need to insert a "0" for. Also I need values less than 6, but when I put <'6' in the expression is says data type mismatch. any suggestions?
    Reply With Quote Reply With Quote
  2. 11-28-2011, 04:09 PM #2
    kwooten
    kwooten is offline Competent Performer
    Windows XP Access 2007
    Join Date
    Jun 2011
    Posts
    255
    nevermind.. i figured it out
    Reply With Quote Reply With Quote
Please reply to this thread with any new information or opinions.
« Previous Thread | Next Thread »

Similar Threads

  1. Total Calculation, nz function, not working
    By Jojojo in forum Programming
    Replies: 3
    Last Post: 10-10-2011, 02:33 PM
  2. Total for Row
    By kwooten in forum Reports
    Replies: 7
    Last Post: 08-31-2011, 01:51 PM
  3. Total's Box
    By Bike in forum Forms
    Replies: 1
    Last Post: 03-31-2011, 12:15 PM
  4. total many fields by function
    By thetuyen in forum Access
    Replies: 2
    Last Post: 03-08-2010, 08:43 PM
  5. Want function to get current function name
    By Davis DeBard in forum Programming
    Replies: 2
    Last Post: 08-13-2009, 05:02 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
  •  

Forum Rules

Other Forums: Microsoft Office Forums