Help with Outer Join query in Acess 2003

[vaddi]

hello,

I have query , which has got 2 outer joins. The query is:

SELECT     A.Project_ID, A.Title, A.comm1 AS Comments, A.Partner AS PM, A.Staff_Assigned AS TL, A.Contact_Name AS FL, A.MD, A.Status, A.Project_Type, 
                      ISNULL(B.Delivered_Date, B.Delivery_Date) AS Start_Date, ISNULL(C.Delivered_Date, C.Delivery_Date) AS End_Date
FROM         dbo.PROJECT A  LEFT OUTER JOIN
                      dbo.PROJDATE B ON A.Project_ID = B.Project_ID AND B.Date_Type = "Start Date" LEFT OUTER JOIN
                      dbo.PROJDATE C ON A.Project_ID = C.Project_ID AND C.Date_Type = "End Date"

Can anybody help me out the error with this. I get an error : at dbo.PROJDATE B ON A.Project_ID = B.Project_ID AND B.Date_Type = "Start Date" .

Do I need to use any parantheris or change anthing.

Thanks

[Rabbit]

If there's a space in a name you need to enclose the name in [ brackets ]

[NeoPa]

For starters, it looks like your (two) ISNULL() function calls are invalid. IsNull() takes a single parameter. It looks as though you want to be using Nz() in place of IsNull().