Bring two different items from a linked table into a report

[DrSmyth]

My report is based on two tables a and b and i'm using a db2 database. Table a is my main table with information relating to a particular person. Table b is a diary table with various events and dates of things that a person does or has to do.


I want to have a single report that details the dates of two different events from table b, the trouble is if i try and make a single report that details all the information in one go then the query starts looking for items with both the events (Some people may have only one of the events). This limits my results

If i do it as two tables and link them together in a single report then the dates from the secound query all change to the same single date as i link the two tables together in m report.

Anybody know why i'm having such trouble???

 

[DrSmyth]

Doh,

Think that i've been taking my stupid pills today....... I had actually forgotten to include the common field when i linked the two reports together...

After doing this it all worked fine!!!!