Query Help Needed

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

ChrisP

I have a Query that is like a Service Bill and I use it
for a Report that is a service bill that I want to print
out.

My query is working fine, but a minor flaw.
I have a Case which contains Issues. These Issues can
contain parts or not. My query displays all the Issues
for a particular case, but the way I set it up when
adding the Issue_Parts table it will only display issues
that contain parts.

(1)I want to be able to display All the Issues with or
without their parts for a specific Case.

This is basically between 3 tables; Case_t, Case_Issue_t,
and Case_Issue_Parts_t.

I have gone so far as to create a DUMBY part record in
the Case_Issue_Parts_t if an Issue doesn't have a part.
One idea I have is to display what my query is displayin
now as long as the Serial# not = 0, which signifies the
DUMBY part.
(2)How can I do this?

Also, if the DUMBY part idea isn't a good solution. How
can I set it up to display what I asked in (1)? Lastly,
any ideas even if the DUMBY part is a good idea?

Thanks ahead of time
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

1) Open Access (I'm using Access 2002, but should work for all versions
w/ minor variations).
2) Click the Help menu item.
3) Click the Contents tab of the Help dialog box.
4) Click the chapter "Microsoft Jet SQL Reference"
4a) Click the subchapter w/ the same name.
5) Click the chapter "Data Manipulation Language"
6) Click the topic "LEFT JOIN, RIGHT JOIN Operations"

Read the topic. Apparently, Microsoft believes that Access/JET has
LEFT/RIGHT JOINs. My experience has also shown the same.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQSpq4oechKqOuFEgEQJq7ACg2V8nswirP6Jh1pwm4sg0fr1+DacAn19V
Pp1t3GU6z1PZDbElCLIfHi2c
=cJYO
-----END PGP SIGNATURE-----
 
OK, can you copy and post the SQL of your query?

(Possibly unneeded instructions follow)
Open the query
Select View:Sql from the Menu
Select all the text
Copy it
Paste it into the message

This might give us a hint on how to help you. It is likely that all you need to
do is to change an INNER JOIN to a RIGHT JOIN or to a LEFT JOIN.
 
Back
Top