Link to home
Start Free TrialLog in
Avatar of Rahul Sehrawat
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_Compare

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
Avatar of tygrus2
tygrus2
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial