query not working properly

[JonathanAnon]

I am having trouble with this one...

I have a table with records of each product sold.

saleid | producttype | clientname | value

and a table that contains the calls logged against each product sold.
(ONE-MANY)

saleid | calldate | problem.

I am trying to create a report that will show
-----------------
clientname
product

calldate problem (1)
calldate problem (2)
-------------------

This works fine for all records that have a call logged against it. BUT if a record does not have any calls logged against it, then nothing is listed on the report.

There is no option to use multiple queries on the same report, aside from Subforms which I dont want to use.

Any ideas?


then lists the call

 

[RuralGuy]

Are you using a LEFT JOIN in your query?

 

[JonathanAnon]

Much appreciated thats it. Must look up all the table join types.
Changed from INNER JOIN, the default on the query that was suggested:
http://office.microsoft.com/en-gb/access/HA010550991033.aspx
to LEFT JOIN and it seems to work fine.

Had to change to SQL view. Must remember that one for the future. thanks again.

 

[RuralGuy]

If you open your query in design view and RightClick on the Join lines, you can view the JoinProperties.