Re: AS400 Query and floating point decimal field

Mike,

Perhaps I don't understand what you mean by floating point decimal.
If you mean it has many decimal places and you want to display or print
a value with only 2 decimal places then do:

Use Specify Report Column Formatting and change the decimal digits.

Or

Use Define Result Field and define a new field with 2 decimal digits and
display or print the new field.

Greg

-----Original Message-----
From: mandis-inc@xxxxxxx [mailto:mandis-inc@xxxxxxx] 
Sent: Wednesday, February 21, 2007 7:19 AM
To: MAPICS-L@xxxxxxxxxxxx
Subject: [MAPICS-L] AS400 Query and floating point decimal field

I am writing an AS400 query.  One of the fields is a floating point
decimal.  How would I convert this floating point field to a regular
decimal (7.2. numeric)?  The report writing tool is AS400 query.

TIA
--
Best regards, 

Mike Dreimiller 
Mandis Inc. 
410-526-5996 
Mandis-Inc@xxxxxxx
_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.