Results 1 to 4 of 4
  1. #1
    ragsgold is offline Access & Excel Developer
    Windows XP Access 2000
    Join Date
    Oct 2009
    Location
    Denver,CO
    Posts
    51

    Thumbs up Rounding off values in Form pivot table values

    Hi All ,



    I need a solution to round off values in the pivot table built via forms. In the attached ppt you would see the average broadvast age field with decimals i want that to be rounded without decimals.

    This pivot is built on a query in the same DB , I had tried changing the decimal to ZERO both in the specific query filed + also in the source table but none is working. All data upto the stage of query i had not used average function.

    Only in the pivot i had used an average calculation and i am unable to round off.

    Need your help !

    Thanks in advance

  2. #2
    llkhoutx is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Location
    Houston, Texas USA
    Posts
    373
    Use
    Code:
    Round([fieldName],Noof digits
    in the approopriate form, report or query.

  3. #3
    ragsgold is offline Access & Excel Developer
    Windows XP Access 2000
    Join Date
    Oct 2009
    Location
    Denver,CO
    Posts
    51
    If its form where should I add this statement ....right click on the field and add in properties?

  4. #4
    llkhoutx is offline Competent Performer
    Windows Vista Access 2007
    Join Date
    Jan 2010
    Location
    Houston, Texas USA
    Posts
    373
    Use
    Code:
    Round([fieldName],Noof digits
    as the controls "control source" property.

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

Similar Threads

  1. Replies: 8
    Last Post: 02-19-2012, 03:48 PM
  2. Replies: 2
    Last Post: 03-27-2010, 10:52 AM
  3. Replies: 1
    Last Post: 03-27-2010, 06:13 AM
  4. Duplicate Values in table
    By senthilrg in forum Queries
    Replies: 3
    Last Post: 12-18-2009, 09:24 PM
  5. Table values in forms
    By xzxz in forum Access
    Replies: 3
    Last Post: 10-28-2008, 08:29 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