Really?ConcatRelated() function doesn't work in query.it is unknown
Expr1: ConcatRelated("CrewName","QryCrewStudy","QryCrewStudy.Rank = """ & [Rank]![Rank] & """ AND QryCrewStudy.On_Date = #" & Format([Dated],"mm/dd/yyyy") & "#","CrewNameRev")
It is not a built-in access SQL function, but you need to make a user defined function.ConcatRelated() function doesn't work in query.it is unknown
Why it doesn't work for me ?Really?
View attachment 94630Code:Expr1: ConcatRelated("CrewName","QryCrewStudy","QryCrewStudy.Rank = """ & [Rank]![Rank] & """ AND QryCrewStudy.On_Date = #" & Format([Dated],"mm/dd/yyyy") & "#","CrewNameRev")
Hi. Your expression appears to be trying to concatenate the "CrewName" column from a query called "QryCrewStudy." Looking at the file you posted, I don't see that query, nor do I see a column called CrewName in your table.Why it doesn't work for me ?
I want to do group by Aircraft Type,Aircraft Manufacturer Serial Number,and Event Type fields then concatenate Aircraft Event Text (Corrective Action) field.
Can you help how to do that ?
Thank you
@theDBguy
The crewname code is mine, from my bibbys db, just to show the OP that the function does work in a query.?
Expr1: ConcatRelated("CrewName","QryCrewStudy","QryCrewStudy.Rank = """ & [Rank]![Rank] & """ AND QryCrewStudy.On_Date = #" & Format([Dated],"mm/dd/yyyy") & "#","CrewNameRev")@theDBguy
The crewname code is mine, from my bibbys db, just to show the OP that the function does work in a query.?
Hi. Not sure if this is what you want; but hopefully, it will give you some idea.
If you imported the query from the file I posted, then make sure you import the Module "modDBguy" as well.
I really appreciate that .my problem with this code solved .Thank yousee Query1.