Find solution
How to convert my SQL query to MS Access query?

MS Access Query Query

  • Complicated (or probably not complicated) MS Access question that I'm not sure how to google for. 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.

  • Answer:

    What you want is to play with the join properties (you can right click on the join in your query) to include ALL from Sequences. If you google join properties access you can find examples for your version.

Just this guy, y'know at Ask.Metafilter.Com Visit the source

Was this solution helpful to you?

Other answers

desjardins: he needs a left join, not an inner join OP: for the love of God, rename "ID" to "TrainServiceID" everywhere

thelonius

Thanks! Such a simple solution. That has been annoying me for HOURS! Problem is well and truly 100% perfectly solved.

Just this guy, y'know

SELECT Sequences.*, Areas.Area FROM Sequences INNER JOIN Areas ON Sequences.Node = Areas.Node;

desjardins

Thanks, thelonius, I have actually done that in most places, but your point is well made. I'll go and make sure that's the case.

Just this guy, y'know

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.