Hi Jason,
Thanks for coming back to me. Here is a copy of the source code from the page in action on the site:
Line 272 and 273 show the grand total to be GBP 17.20 which is correct.
Line 300 gives the correct commission value (in this case 10%) as being 1.72 (no currency setting. The commission is calculated using the results from a recordset and the Grand Total of the session)
So, the total is correct and the commission value is correct too....yet the Save Summary to Database behaviour is not saving this figure to the database....but the hard coded 'ComPaid_ord' is being entered as '0'.
Just to recap, in the database, the commission field called 'Ord_Comm' (where the form value id=commission from line 300 (in the attached source code) should be stored) is set to FLOAT.
as everything appears to be correct....I still can't see what's going wrong with it!
Many thanks,
Martin