Need Help - Syntax Error (Missing Operator)

[carlos83]

Hi,

I am quite new to SQL and trying to build my own access program.

I have problem with the following query which keeps giving me error.
IIF(([qryCombinedbyFormID.UWFinalRecDate] <> ""), GetNoOfWorkDaysExcludeHolidays([UWFinalRecDate],[BDRecDate], GetNoOfWorkDaysExcludeHolidays([UWOriRecDate],[BDRecDate]) AS TAT

Tried changing the brackets position to no avail.

Appreciate your kind guidance.

Thanks.

 

[georgedwilkinson]

You have 4 ( and 2 ). It is unclear where the functions end.

 

[carlos83]

Hi George,

OMG, i really missed out the 2 brackets.
Many thanks. It works now.