Community Forum     Helping YOU do what YOU want with YOUR data.
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
JKW  
#1 Posted : Tuesday, April 20, 2021 10:09:45 AM(UTC)
JKW
Rank: Advanced Member

Reputation:

Groups: Registered
Posts: 62

I am trying to get an export out to an AGS file where the Depth is always a set number of decimal places, eg 0, 0.15 and 1.2 would be: 0.00, 0.15 and 1.20 respectively.

I have attempted a few things. 

Firstly setting the GEDTS export to a function call like: Format(Top_Depth,'#.00')

I also altered the Access DB AGS.mdb table as well: setting the field format to a Decimal number with a preset Format and decimal place precision. 

Neither of these have forced the exported number to the set number of decimals, although they are correctly rounding and setting when the number is larger. 

Any thoughts on how this might be achieved? 

JKW

You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.