Problem to display the total value (taken from datagrid) as Currency.

[awinnn]

Hi,
I'm having problem to display the grand total as a Currency format. The value is taken from the datagrid. This is what i've done..

Set rsgtot = New ADODB.Recordset
rsgtot.Open "SELECT Sum (price * pt) AS [GrandTotal] FROM 
            [Order Details] where SN=" & "'" & txtFields
            (0).Text & "'" & "group by SN", db
txtgtotal.Text = FormatCurrency(rsgtot!grandtotal)

My problem is, it's not working. The value should be displayed as a Currency format.
Any idea? Thanx in advance..

 

[SemperFiDownUnda]

what happens if you use
txtgtotal.Text = Format(rsgtot.fields("grandtotal").value,"Currency")

?

Hope I've been helpful,
Wayne Francis

If you want to get the best response to a question, please check out FAQ222-2244 first