I have this query which worked great in Access, but now that my data is in MS SQL, it is giving me an error when I try to run it. As a note, both items in this query are queries. I can open each query without issue however, when I try to open the statement below, I get the error.
Code: Select all
Forms!fQueueContractWarranty!Child1.Form.RecordSource = _
"SELECT [qContract_PM_Warranty_Noincidents].* " _
& "FROM [qContract_PM_Warranty_Noincidents] LEFT JOIN " _
& "[qContract_EXT_Warranty_Incidents] ON [qContract_PM_Warranty_Noincidents].[ID]=[qContract_EXT_Warranty_Incidents].[ID]" _
& "WHERE [qContract_EXT_Warranty_Incidents].[ID] Is Null and ([qContract_PM_Warranty_Noincidents]![equip]![warranty_exp_date]) >= "_
& Me.cbo1.Value & " and ([qContract_PM_Warranty_Noincidents]![equip]![warranty_exp_date]) <= " & Me.cbo2.Value & " order by ([qContract_PM_Warranty_Noincidents]![Name_24])"
Thanks,
Mark