ASP and Datbase Query
Posted on 1998-06-09
I have a problem which I cannot work out how to solve. I am using ASP to send two values to an Access database. I then want to automatically perform some basic maths on the two fields in the database storing the result in a third field which I then want to be displayed using another ASP page. My problem is that I am told that Access does not support Calculated fields directly in tables and I must use a query. But how can I then access this query in ASP which only appears to interrogate tables.
Please help if you can. I am new to both Access and ASP so need a bit of help...