I am getting an error on this line, but not sure what is causing it. I have this all as one line (no breaks like shown below) in the VBE but i added the breaks for cleanliness of view in the window
How do I alter so this does no longer produce a compile error?
Code:DoCmd.RunSQL ("SELECT [HKI].[SalesID], ConcatRelated("Part","[HKI]","SalesID = '" & [SalesID] & "'") AS Part, ConcatRelated("Amount","[HKI]","SalesID = '" & [SalesID] & "'") AS Amount INTO [Export] FROM [HKI]")