Query help

  • Thread starter Thread starter Golfinray
  • Start date Start date
G

Golfinray

I am trying to write an iif statement for a query but keep getting it wrong.
I am pulling from 3 tables, 06-07 projects, 07-09 projects, and project type.
I want the query to look like this:
06-07 project # project type 07-09 project # project type
00001 new addition 00002 new
HVAC
00003 new roof
00004 new plumbing 00005 new
electrical
00006 new flooring
00007 new cabinets 00008 new
sidewalks

It looks like this:
00001 new addition 00002
new HVAC
00003 new roof 00002
new hvac
00004 new plumbing 00005 new
electrical
00006 new flooring 00005
new electrical

In other words, I want to return nulls (nothing) where there is no
information.
Thanks so much!!!!
 
Post the SQL statement of the query as it is right now, so that we can
better understand your setup.
 
Back
Top