I am attempting to create a pivot table that will cover information across four tables, so that the information can all be sorted and moved about at will. Unfortunately, I have run into 2 problems.
1. It seems I can only put together tables that are directly related to each other.
2. It seems I can only put together records that are directly related to each other.
Is there any effective solution to this? In Excel, it would be a fairly simple matter, but I'm new to Access and for some reason this silly program refuses to do my bidding. Any help you could provide would be much appreciated.
1. It seems I can only put together tables that are directly related to each other.
2. It seems I can only put together records that are directly related to each other.
Is there any effective solution to this? In Excel, it would be a fairly simple matter, but I'm new to Access and for some reason this silly program refuses to do my bidding. Any help you could provide would be much appreciated.
