stored procedures is the solution here

think sql as calculator

select (cost * quantity) as total from mytable...

possible with stored procedure with simple if else loop

whats wrong with access or mysql??