It's the join. With an inner join, you need a matching record in both tables
or a record won't be returned even if there is a record in one or the tables.

In query design view, double click on the line between the two tables.
Select Option 2 which is a Left Join. See if that works. If not, try Option 3
which is a Right Join.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Hannah" wrote:

I've had a hunt around and couldn't find an answer to this particular query
but I'm really sorry if it's on here somewhere already!

I'm setting up a database to store and analyse questionnaire data. I've got
11 different questionnaires so I want to have a table (call it QuestTable)
which lists each questionnaire type and gives it an ID number. Each
questionnaire will then be linked to this table using that ID number. So far,
so good...except when I go to query tables linked to QuestTable, no records
are returned for any query. I wondered if this was to do with the
relationships but these seem okay as far as I can tell. Any advice hugely
appreciated!