...or join the location table to tjhe road intersection table 3 times (once for each required element)
whether that would work right know I dunno, mainly because my Joins in Access are a bit rusty (Access/JET uses its own syntax for joins) however you can do this yourself using the query designer (its one of the few times the query designer pays for itself in my books. place the location table on the designer 3 times, drag and drop from the roads / intersections table to each instance of the location table specifying that you want all the values from the roads / intersection table and whatebver rows match from each instance of the location table.
FROM [Roads / Intersections] as RT
left join Location as LT1
on RT.[Road Name / Intersection] = LT1.[Road/Intersection]
left join Location as LT2
on RT.[Road Name / Intersection] = LT2.[Start Road]
left join Location as LT3
on RT.[Road Name / Intersection] = LT3.[End Road]
however that does presume that you can actually use / as a symbol inside a table or column name. http://office.microsoft.com/en-gb/ac...#_Toc262648754 suggests not.
I'd strongly recommend that you stick to the guidelines for naming columns and or tables..
dont use spaces
don't use reserved words
use either capitalisation or underscores to separate words (eg EndRoad or end_road).
don't be overly verbose in naming columns or tables (use abbreviations where they make sense
of course you could take all the fun out of the process by normalising your design
have a read of:-
then have a look at:-
I'd rather be riding on the Tiger 800 or the Norton