Hi,

I have an Advantage Database and try to get the following code to work as a
simple asp page:

Code:

SELECT
f140.customer As CustomerNumber,
f75.description AS CustomerName,
f75.description2 AS Details,
f42.description AS Branch,
f140.masterpolicy as Masterpolicy,
f140.policy as Reciept,
f103.description AS Insurer,
f145.description AS Category,
f140.characteristic AS Characteristic,
f140.issuedate,
f140.effectivedate,
f140.expdate,
f140.canceldate,
f140.grosspremium as Premium


FROM
fpotype f145,
fcustomr f75,
finscomp f103,
fbranch f42,
fpolicy f140

WHERE
f145.code=f140.category
AND
f75.code=f140.customer
AND
f103.code=f140.insco
AND
f42.branchcode=f140.branch
and
f140.agent=788

order by customername
..



The result works fine, just I get nuts with the field

f140.grosspremium as Premium

It shows up as without formating as currency (in the ASP Page), any
suggestions??

Advantage Database 7.1.0.10

Thank you in advance

Anthony