Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Access Query Problem

Avatar of matt_m
matt_m asked on
Microsoft AccessMicrosoft Excel
4 Comments1 Solution383 ViewsLast Modified:
Hi Experts
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.
Avatar of peter57r
peter57rFlag of United Kingdom of Great Britain and Northern Ireland image

Our community of experts have been thoroughly vetted for their expertise and industry experience.

This problem has been solved!
Unlock 1 Answer and 4 Comments.
See Answers