Rahul Sehrawat
asked on
Access Query - Compare Table
Hello,
I have attached my access file. In this package, we want to compare three quotation given to us by 3 suppliers stored in 3 different tables.
what I want is when the user click compare, it should open a report comparing the total cost for each item.
For example :
Form Name: Add_Quote_From_Supplier_Co mpare
Choose Request I.D as 3 from the drop down menu. This will populate all the controls in he tab control.
If you notice Item's name as same. Now what I want as soon as the user click compare, it should compare the total cost for all the items in a report. something like
Item Name Supplier 1 Supplier 2 Supplier 3
-------------------------- ---------- ---------- ---------- ---------- --
item1 total_cost total_cost total_cost
item2 total_cost total_cost total_cost
item3 total_cost total_cost total_cost
item1 total_cost total_cost total_cost
Compare.mdb
I have attached my access file. In this package, we want to compare three quotation given to us by 3 suppliers stored in 3 different tables.
what I want is when the user click compare, it should open a report comparing the total cost for each item.
For example :
Form Name: Add_Quote_From_Supplier_Co
Choose Request I.D as 3 from the drop down menu. This will populate all the controls in he tab control.
If you notice Item's name as same. Now what I want as soon as the user click compare, it should compare the total cost for all the items in a report. something like
Item Name Supplier 1 Supplier 2 Supplier 3
--------------------------
item1 total_cost total_cost total_cost
item2 total_cost total_cost total_cost
item3 total_cost total_cost total_cost
item1 total_cost total_cost total_cost
Compare.mdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.