MS Access Query Query
February 20, 2012 8:46 AM Subscribe
Complicated (or probably not complicated) MS Access question that I'm not sure how to google for.
posted by Just this guy, y'know to computers & internet (5 answers total)
So I have a table called Sequences which contains SeqNum (primary key), ID (a train service ID) and Node (a place the train goes through).
I have another table called Area Boundaries which has a smaller subset of nodes and an associated area.
I want to do a query which shows all the records from Sequences and then adds on the end if there is an associated area. Roughly 1 node in 30 has an associated area. If there isn't an associated area I just want a blank entry.
Right now I am getting a result which shows only the nodes with the asociated area and not the whole thing. I've tried messing about with "Is Null", "Is Not Null" and " " " ", but to no avail.