I'm a bit new to access so apologies in advance if this has a simple answer!
I have just set up a relational database in access consisting of four tables. Three of these tables consist of data with headings of an unique code, date and size. The fourth table has a main code and the matching code for each of the three tables so as to tie the three different codes in the three tables together (due to the source data they are different in all three tables although they refer to the same thing).
The problem is that since the three tables are not all complete sets when I run a query from excel, with the three tables linking to the reference table the only data that will show up is limited by the smallest data set. The fields that I want in the query are the main code from the reference table and then the amounts from each of the the data tables (if any) that link to that reference code.
Following this I was wondering if there was a way to structure a query of the four tables so all the data will show up even if there is an amount coming in from one table? I know I could add all the codes to each of the three data tables and put zeros in but would rather not do this.