Hi,
I am new to access and databases. I have 2 tables with the respective fields:-
1) tblItemMaster - ItemCode(PK,Related), ItemDes, Product, Rate
2) tblQuotationDetail - ReferenceNo(PK), QuotationDate, ItemCode(Related), Qty, Total
I need to calculate the Total by multiplying Qty with Rate...