Showing all items in a table in a query

Hi Louise, thanks for your query. It's a little difficult to advise you without seeing the database you are working with, but I would suggest you double check that the tables are normalised and their relationships are set correctly with primary and foreign keys in place. After that it should be a matter of simply dragging the relevant fields into the query. Your problem certainly sounds like the relationships haven't been set correctly, or your table structures need to be looked at so clarify these first.

Hope this helps,

Anthony