Database results

[Daniel]

I have an .asp page that saves records to an Access
database, one of the fields is for currency, the user
enters the number and when I look at the table in access
(data type = currency), it displays $47.20. When I do a
search via another .asp page, the results come back in
number format, not currency (ie. 47.2 instead of $47.20).
Suggestions?

 

[grw]

<%=FormatCurrency([your input])%>

 

[Daniel]

This is what the DRW generates for me:
<%=FP_FieldVal(fp_rs,"TotalDue")%>
I have tried:
<%=FormatCurrency[FP_FieldVal(fp_rs,"TotalDue")]%> and
also tried:
<%=FormatCurrency(FP_FieldVal[fp_rs,"TotalDue"])%>
and when I try to save the page I get the pop-up "The
contents of a FrontPage component have been modified.
These contents will be overwritten when you save this
page." Frontpage discards the FormatCurrency part and
puts the original generated result back in. What am I
doing wrong?

-----Original Message-----

<%=FormatCurrency([your input])%>

I have an .asp page that saves records to an Access
database, one of the fields is for currency, the user
enters the number and when I look at the table in access
(data type = currency), it displays $47.20. When I do a
search via another .asp page, the results come back in
number format, not currency (ie. 47.2 instead of $47.20).
Suggestions?

.

 

[grw]

<%=FormatCurrency(FP_Field(fp_rs,"TotalDue"))%>

To prevent FP from modifying the code, remove the grey coloured code that
surrounds it (just inside that table cell)

This is what the DRW generates for me:
<%=FP_FieldVal(fp_rs,"TotalDue")%>
I have tried:
<%=FormatCurrency[FP_FieldVal(fp_rs,"TotalDue")]%> and
also tried:
<%=FormatCurrency(FP_FieldVal[fp_rs,"TotalDue"])%>
and when I try to save the page I get the pop-up "The
contents of a FrontPage component have been modified.
These contents will be overwritten when you save this
page." Frontpage discards the FormatCurrency part and
puts the original generated result back in. What am I
doing wrong?

-----Original Message-----

<%=FormatCurrency([your input])%>

I have an .asp page that saves records to an Access
database, one of the fields is for currency, the user
enters the number and when I look at the table in access
(data type = currency), it displays $47.20. When I do a
search via another .asp page, the results come back in
number format, not currency (ie. 47.2 instead of $47.20).
Suggestions?

.