Results 1 to 4 of 4
  1. #1
    billgyrotech is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    45

    Rounding and Formatting Issues

    I would greatly appreciate some help on a couple of issues:

    1. Workorders by Customer subform is not calculating properly:
    The currency is rounding (how to prevent this) so the result is not the same as on the Workorder and the Amount Due is blank.

    2. When opening the Workorder on the heading it shows the WorkorderID not formatted as 5 digits like on the field WorkorderID. I would like to show it as 5 digits.

    Thank you very much for any suggestions,


    billgyrotech
    Last edited by billgyrotech; 08-09-2011 at 03:13 PM.

  2. #2
    apr pillai's Avatar
    apr pillai is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    May 2010
    Location
    Alappuzha, India
    Posts
    209
    Database is attached after the requested change.

  3. #3
    billgyrotech is offline Advanced Beginner
    Windows XP Access 2003
    Join Date
    Jul 2011
    Posts
    45
    I tried to open the Workorder by using the command button and I get error message the save isn't available now. Also, when opening it says read only. Do you know why?

    Thanks,
    billgyrotech

  4. #4
    apr pillai's Avatar
    apr pillai is offline Competent Performer
    Windows 7 64bit Access 2007
    Join Date
    May 2010
    Location
    Alappuzha, India
    Posts
    209
    I have compacted the database under Access2007 for reducing its size, may be that is the reason.

    Database after change is attached. This time the database is not compacted.

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

Similar Threads

  1. Rounding
    By BLD21 in forum Reports
    Replies: 5
    Last Post: 06-20-2011, 01:06 PM
  2. Rounding problem
    By chavez_sea in forum Access
    Replies: 6
    Last Post: 03-09-2011, 09:01 PM
  3. Expression rounding
    By Scorpio11 in forum Queries
    Replies: 2
    Last Post: 03-07-2011, 01:29 PM
  4. rounding digits
    By giladweil in forum Access
    Replies: 1
    Last Post: 09-01-2010, 03:11 AM
  5. Rounding off
    By Alex Motilal in forum Access
    Replies: 4
    Last Post: 12-20-2009, 12:47 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