Search results

I'm starting to learn VBA. Can someone please help with this. If IsNull(Me.cboActors) Then myActors = "[ActorsID] like '*'" Else myActors = "[ActorsID] = " & Me.cboActors End If It's telling me I have a missing operator '[ActorsID] = 14 andand'

Hello All I'm trying to make a cocatenation query using Allen Browne's function. I can't post the link as this is my first post sorry. The query is this SELECT qryMerge.FileName, qryMerge.Length, ConcatRelated("Categories","qryMerge","ClipID = " & [ClipID],"ActorsID = " & [ActorsID]) AS...