Saved Bookmarks
| 1. |
Solve : How can I subtract two fields from a database table name Table1 in Access 2002?? |
|
Answer» DEAR Sir I have TWO FIELDS under a database table named as Table1 in Microsoft Access 2002. Table1 has GOT two fields purqty & suppqty which contains numeric values. I want to subtract suppqty from purqty and store result in another field named as BALANCE in Table1. The SQL statement I have written is as follows. But it is not working. SELECT Table1.item, Table1.purqty, Table1.suppqty, Table1.balance FROM Table1 WHERE (((Table1.balance)=[table1]![purqty]-[table1]![suppqty])) GROUP BY Table1.item, Table1.purqty, Table1.suppqty, Table1.balance; Please help. Regards Pervez You should use a Query for that calculated field, not a Table. |
|