Adding To Recordset

[tekyge]

Does anyone know how to add two recordsets togather for calulation. Want the two below to add and give one figure.

FormatCurrency(rs("Payment + APayment"))

 

[Sheco]

Please rephrase the question, unless you mean something like this:

x = rs1("MyField") + rs2("MyField")

 

[tekyge]

I have to fields one is Payments the other is APayments If Payments = 100.00 and APayments = 75.00 I need them added togather =ing 175.00

 

[Sheco]

You might also consider adding them up from the database side... before the fields even go into the recordset.

Imagine that you used a SQL statement like this;[TT]
SELECT
Payments,
APayments,
(Payments + APayments) As 'MyTotal'
FROM
MyTable

[/tt]

 

[tekyge]

Thanks guys I came up with anouther solutions I am going to calulate at the time of invoice rather than on the asp page. Thanks for your help