Query Help Needed

  • Thread starter Thread starter ChrisP
  • Start date Start date
C

ChrisP

I have created a Report that will display a service bill
and this report uses a query as it's source.

The query I am currently using will not display the
appropriate information I need that will be displayed on
my Report.

I have a CASE which has ISSUES, and these ISSUES can have
PARTS associated with it.

I am leaving out other tables from my query question
because they are not necessary. I need my query to
display all the information in my Case table, Issue
table, and my Parts table if there are any parts used or
not. However, it shows the correct records if I dont add
the PARTS table to my query. IF I add my PARTS table to
the query it will only display the records that have
parts.

I need my query to display all the records and their
information whether or not it contains parts. IF it
contains parts in that particular ISSUE then display the
fields like, Name and Cost from the PART table.

I hope this makes sense because I tried to simplify it.
Thanks for your help a head of time,

Chris
 
IF I add my PARTS table to
the query it will only display the records that have
parts.
Click to expand...

Select the Join line in the query and choose Option 2 (or maybe 3) -
"Show all records in ISSUES and matching records in PARTS".
 
Back
Top