Syntax Error

[Guest]

I have been given this code below to use but I keep on getting a syntax error
and I cannot see it. Please can anyone help.

Start Date: (SELECT c.calendar_date FROM Calendar AS c WHERE
c.work_day = 1 AND c.holiday = 0 AND c.calendar_date < [a.Ship
Date] AND c.calendar_date >= DATEADD("d",-(([a.Lead Time Days]
* 2) + 14),[a.Ship Date]) AND [a.Lead Time Days] = (SELECT
COUNT(* ) FROM Calendar c2 WHERE c2.calendar_date < [a.Ship
Date] AND c2.calendar_date >= .calendar_date AND c2.work_day
= 1 AND c.holiday = 0))

Thank you

 

[Roger Carlson]

In the second to the last line, you have ".calendar_date". I'm assuming it
should be "c.calendar_date"


--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

[a.Ship Date] [a.Lead Time Days]
I do not see a table or alias of "a" in the FROM clause.

c2.calendar_date >= .calendar_date
Somthing is missing in front of the second calendar_date. Probably a c.

 

[Guest]

Found another I think:
AND c.holiday = 0))

As this is in the subquery, it probably needs to be:
AND c2.holiday = 0))