Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. andyvb

    simple calculation with currency

    Hi there This is all my coding!, the rs should set the variables as &quot;988.5&quot; as this is the result of the SQL query. my script: <%@LANGUAGE=&quot;VBSCRIPT&quot;%> <HTML> <P><%=rs2(strpn)%> <P>booking for the weeks beginning... <% If...
  2. andyvb

    simple calculation with currency

    Thanks for the reply, i gave this a go and now i get the error below: Microsoft VBScript runtime error '800a000d' Type mismatch This error goes away when i specify a format for my variable! e.g. FormatCurrency or FormatNumber, but then i get the concat again!? Any suggestions? Thanks Andy
  3. andyvb

    simple calculation with currency

    Hi there, Please can someone advise, I'm trying to get the sum of two variables (that as taken from a select statement in SQL). The result of the values are are in currency format i.e.£XXX.XX but for some reason i keep on being returned the same figures concated e.g £10.50£15.30 and not £25.80...

Part and Inventory Search

Back
Top