Louise has attended:
Access Introduction course
Showing all items in a table in a query
Hi, I'd like to show all 'organisations' from Table1 in my query with Table2 and Table3. There are 563 organisations in Table1, but not all of these are listed in Tables 2 and 3 (since some organisations are recent joiners to our programme). How do I set the criteria in the query to show all organisations from Table1 regardless of whether or not they are in the other tables? Is this possible? Right now, I am adding the organisation where it is missing to the other two tables. Thanks for your help!
RE: 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
Will be marked as resolved in 5 days
Notice: This is an automated message. Due to inactivity, this forum post will be marked as 'resolved' if there are no further responses in the next 5 days.
