Hello I am trying to create a basic application + reporting solution using ms access.
I have a table1 - to store invoice details ( coming from an input form)
Example
Invoice Table
Invoice ID - 00001 , Qty - 2, ShipFrom - Germany, ShipTo - France, etc
"ShipFrom" & "ShipTo" are look up from two other table tbl_Shipto & tbl_ShipFrom
I have another table which stores VAT info by country
VAT Information
Germany 20 % ,France 19 %
My Question: How do I get VAT for both Germany & France from the same table on my report?
Report needs to look like below :
Invoice ID Qty
00001 2
Ship From VAT
Germany 20 %
Ship To VAT
France 19%
Thanks!