Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have the following expression
Num([Drug Code],'000000') as [Drug Code]
How can the above expression be adapted to change negative numbers into positive numbers in cases where these negative numbers exist in addition to formatting a number into a six digit one when required?
Regards
Chris
try this
Num(fabs([Drug Code]),'000000') as [Drug Code]
Hi,
Use Fabs() to convert negative to positive.
Fabs(Num([Drug Code],'000000')) as [Drug Code]
Regards,
Jagan.
Prem, many thanks, i will try it out and revert
Regards
Chris
Jagan, many thanks, i will try it out and advise accordingly
Regards.
Chris