Database results and decimal places

[Ian]

Does anybody know how to make a field displayed from a database using the
FP2003 Database Results wizard which is a currentcy field display with two
decimal places?

I've looked everywhere!

Many thanks

Ian

 

[Kathleen Anderson [MVP - FP]]

http://www.spiderwebwoman.com/resources/dbrwtipsandtricks.asp#currency

--
~ Kathleen Anderson
Microsoft MVP - FrontPage
Spider Web Woman Designs
http://www.spiderwebwoman.com/resources/
Connect to the Newsgroups with Outlook Express
http://www.tushar-mehta.com/misc_tutorials/oe_ng/index.html

 

[Ian]

Kathleen,

Many thanks for the information, I've have a play.

Regards

Ian

 

[Ian]

Kathleen,

I wonder if you can help, I've tried adding the format command to the SQL
statement below and keep getting syntax errors. Any advise on the best
place to insert the string?

SELECT record.SIZE, Count(record.SIZE) AS CountOfSIZE, Sum(record.COST) AS
SumOfCOST
FROM record
GROUP BY record.SIZE
ORDER BY Count(record.SIZE) DESC , Sum(record.COST) DESC;

The field SumOfCOST contains the value I wish to use the format on.

Many thanks

Ian

 

[Ian]

Don't worry got it!!!

Kathleen,

I wonder if you can help, I've tried adding the format command to the SQL
statement below and keep getting syntax errors. Any advise on the best
place to insert the string?

SELECT record.SIZE, Count(record.SIZE) AS CountOfSIZE, Sum(record.COST) AS
SumOfCOST
FROM record
GROUP BY record.SIZE
ORDER BY Count(record.SIZE) DESC , Sum(record.COST) DESC;

The field SumOfCOST contains the value I wish to use the format on.

Many thanks

Ian