Thanks John, I've been trying to avoid thinking in Excel ways coz that was definitely causing me some serious confusion when I started out. I've been reading as much as I can but its a bit haphazard as I try and create new tables or queries.
In response to your answer, I'm going to have to ask...