Getting all records Help!!!!!!!

[ss188]

Hi,

what I am trying to do is produce a pivot table which shows me where there are gaps in a curriculum for school.

the curriulum has a series of elements that each school department have to comment on by completing a field.

What I am trying to do is produce a table which shows me all the elements and the comments.

At the moment I can produce the query but it only shows mee those elements which have a comment.

I would like to have a query so that it shows me all the elements whether they have been commented on or not.

Any help would me hugely appreciated.

Many thanks

 

[john471]

In query design mode, right click on the line that joins the two tables in question. Choose "Join Properties" from the shortcut menu that pops up.

Depending on the version of access you are using, there may be additional options in the next dialogue box, but it should include a choice of between three types of joins. Choose the type that best describes the results you want. You probably currently have selected "Only include rows where the joined fields from both tables are equal". This is why you only see results that have an entry in both tables. You want to choose one of the other two options.

HTH

Regards

John