Hi
I receive daily 4 Excel files from our vendors. It has pre-defined fields, data changes every day and record vary in lines
I want to consolidate data in access report
How do I this in ACCESS if I have created tables with primary key and also created relationship
Example: Similar table I receive from 4 different vendors daily
There can be one or more common fields across different vendors.
Vendor Broker Security Id Sec Value Value Date A M a 100 02/01/18 A N b 500 02/01/18 A M c 300 02/01/18 A N a 100 02/01/18 A O e 200 02/01/18
I want to use 1st 3 relationship to show values in 4 at total levels and produce daily reports
Can someone assist me.
Thanks
Amit