Felix Geerinckx wrote: > on Tue, 18 Jun 2002 19:11:29 GMT, Kevin Old wrote: > >> I have quite a complicated question and it is mainly about how to >> process the data after I get it out of the database. >> [...] >> I need to perform caclulations on the values as they come out of the >> database....does anyone know of a way to automate this. > > Did you consider performing the calculations within your SQL-statement, > like e.g. > > SELECT a, b, a+b from atable >
This is the correct way to do it. Put the calculation logic in the SQL statement. The only thing I can add here is to use the AS directive: SELECT a, b, a+b AS sum FROM table; Creates a virtual field "sum" in the recordset. Todd W. -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
