Search results

Great thank you

Thank you Pbaldy. like I said just starting to learn VBA. Do you know of any good sites for beginners to learn.

was just working with the cboActors to see what syntax was missing

sorry thought it was in that part of the function. here's the full function i'm working with Dim myActors, myCategories, myGender, myYear As String Dim task1, task2, strCriteria, strCriteria2 As String If IsNull(Me.cboActors) Then myActors = "[ActorsID] like '*'" Else myActors = "[ActorsID] =...

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'

ok go it to work. thank you pbaldy for your help here's the query. SELECT qryMerge.FileName, ConcatRelated("Categories","qryMerge","ClipID = " & [ClipID] & " AND ActorsID = " & [ActorsID]) AS Categories FROM qryMerge GROUP BY qryMerge.FileName, ConcatRelated("Categories","qryMerge","ClipID = "...

ok I attached the database. i'm sorry for being such a pain.

SELECT qryMerge.FileName, ConcatRelated("Categories","qryMerge","ClipID = " & [ClipID] & " AND ActorsID = " & [ActorsID]) AS Categories FROM qryMerge GROUP BY qryMerge.FileName ok for some reason it's not liking the GROUP BY. It still says LEVEL clause includes a reserved word or argument name...

again thanks pbaldy for you quick response but something is still not right. it saying the LEVEL clause includes a reserved word or argument name that is misspelled or missing or the punctuation in incorrect.

SELECT qryMerge.FileName, qryMerge.Length, ConcatRelated("Categories","qryMerge","ClipID = " & [ClipID] & " AND ActorsID = " & [ActorsID]) AS Categories GROUP BY qryMerge.FileName, qryMerge.Length FROM qryMerge; tried this but tells me this. The SELECT statement includes a reserved word or...

thanks pbaldy for the quick reply. Yes i'm trying to filter on two field it concatenates the categories field. before : forrest gump comedy forrest gump romance Now: forrest gump comedy,romance forrest gump comedy,romance would like: forrest gump comedy,romance

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...