qry help

  • Thread starter Thread starter rum23
  • Start date Start date
R

rum23

I have a projects table and a project type table

tblProjects: this table has project no, project name and projecttype fields.
Projecttype field is null for some of the projects.

tblProjectType: this table has ProjectTypeName and FriendlyName fields.

Now I want to get the list of all projects from tblProjects along with their
friendly name from the tblProjectType table. For the projects that have null
in the projecttype should return "null" as their friendly name.

How do I do this in SQL?

Thanks
 
SELECT ProjectTypeName, NZ( FriendlyName, "null")
FROM tableNameHere


Vanderghast, Access MVP
 
Back
Top