Simple Access IF query when no join on tables?
Posted on 2011-10-19
I'm having a few problems with a query that I do
I have three tables that is used in a simple weight loss programme
My table is "Names" and contains a long list of people names and their starting weight , "HalfWayWeight" contains a list of names with their corresponding mid way weight and "EndWeight" contains a list of people names and their corresponding end weight.
My query takes the Names table and then joins midway and end weights. However, sometimes there are no mid or end weight listed. What I'm trying to do is the following:
Get a query that gives the following:
Name, StartWeight, MidwayWeight, EndWeight and gives a 0 if it's missing. So far I've been trying this:
However, this does not work. It does not seem to check if "[HalfWayWeight].[Weight]" is greater than zero if that person is not represented in the MidwayWeight table?
I hope one of you out there have a suggestion on how to do these queries!
Thanks in advance!