(UTC)
  Lantica User Forum › Lantica Discussions › Lantica Discussion › Rounding a money field
(Moderator: Forum Admin)
‹ Previous Topic | Next Topic ›
Page Index Toggle Pages: 1 Send Topic Send Topic Print Print
Normal Topic Rounding a money field (Read 1256 times)
proudpoppy
Full Member
Members
***
Offline


Do What ??

Posts: 420
Location: South Carolina
Joined: Apr 7th, 2004
Rounding a money field
Mar 11th, 2005 at 11:00pm
Print Post Print Post  
How would you go about mass updating a money field to the closest dollar amount?   ???
  
Back to top
 
IP Logged
 
The Cow
YaBB Administrator
*****
Offline



Posts: 2530
Joined: Nov 22nd, 2002
Re: Rounding a money field
Reply #1 - Mar 12th, 2005 at 1:47pm
Print Post Print Post  
Quote:
How would you go about mass updating a money field to the closest dollar amount?   ???


Customers.db has a LE named "Currency":
Code
Select All
var aa as double
aa = @Round(Currency, 0)
Currency = aa


Place the code above in the mass update for any LE. Remember to replace the LE "Currency" with the LE you seek to round.
  
Mark Lasersohn&&Programmer&&Lantica Software, LLC
Back to top
WWW WWW  
IP Logged
 
Page Index Toggle Pages: 1
Send Topic Send Topic Print Print
‹ Previous Topic | Next Topic ›
 
  « Board Index ‹ Board Top  

Lantica User Forum » Powered by YaBB 2.6.11!
YaBB Forum Software © 2000-2025. All Rights Reserved.

Valid RSS Valid XHTML Valid CSS Powered by Perl Source Forge