I would like to add a field to an ASP recordeset. The field would be base 

on a calculation of other fields. Can I do this, or do I need to dothe 

calculation in the data source before pulling the recordset?



Thanks for your help.

Yes, you can do that. All of the fields in the open recordset are available

to be read and written to. Simply use an SQL statement to get the desired

record, read the values, perform the calculation, then set the resulting

value to the desired field and update the record.



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

From: jacqi herber [mailto:jacqlyn_herber@q...]

Sent: Monday, October 08, 2001 2:39 PM

To: Access ASP

Subject: [access_asp] Recordset calculations





I would like to add a field to an ASP recordeset. The field would be base

on a calculation of other fields. Can I do this, or do I need to dothe

calculation in the data source before pulling the recordset?



Thanks for your help.