(Solved) – ‘No value given for one or more required parameters’ IN Operator

(solved)-–-‘no-value-given-for-one-or-more-required-parameters’-in-operator

Using Excel 2007 VBA

Tables in Excel Sheet

using ADODB Connection and Recordset

This works:

select * from [tblBFLC$] where [Body ID] IN (select  DISTINCT [Body ID]  from [tblBody$] where [Luminaire Type]  = 'Interior') and  [LED Type]  = 'COB'

This does not work:

select * from [tblBFLC$] where [Family ID] IN (select  DISTINCT [Family ID]  from [tblFamily$] where [Family]  = 'ACLAP') and  [LED Type]  = 'COB'

I have checked for correct Field names.

Syntax Error:

No value given for one or more required parameters

Leave a Reply

Your email address will not be published. Required fields are marked *