Thanks for the reply. Maybe I should have elaborated. The
reason I need these records is so I can produce a report
that when these three fields have no corresponding numeric
value the report will spit out the records displaying 0.00
for the corresponding numeric field. The client demanded
that these blank records appear. It also adds uniformity
to the report.
Thanks again. Also I am just starting to deal with SQL
programming and this report was throw'n at me to produce
quickly. I was having a heck of a time trying to achieve this.