I am writing a program that is to be able to bill to the 1/10 of the second. The problem is access does not support the function roundup and yet Excel does. So for example if I take a 31 sec call it becomes .516667, and in Excel if I have this number I can format it to only show one decimal after the deciminal point and by using round up Excel converts this number from .51667 to .6. This is what I am trying to acheive, but I can't see to do with out Excel. I can export the data out to Excel to do this, but is there a way that you can use VB that calls Excel for this functinality that would allow me to do this without the export? Because if I export this data then I will have to import the data back in, and eventually the data will be too large to do this.
Any suggestions people can make would be greatly appreciated.
You can also set the table properties to the following for the field and it will convert automatically.
Data Type: Number
Field Size: Decimal
Percision: This depend on on how many # places you need. If the
biggest number you have is say 100 with some decimal
places then set it to 4 etc...
Remove the defualt value if you don't want 0 entered automatically
When I created a table like this I could enter .1565772 (example) and it would convert the number to .2 It would not just display it as .2 and when you put the cursor in the field display the .1565772 it will convert the number to .2