Recent content by Nimmy.K

This the query : SELECT image, ConcatRelated("[AKA/HS1]","[Primary]",",") FROM [Primary]; The third argument is anywaz declared as an optional.

I have passed the third argument as ALIAS but no luck. the image field holds the images name which i m using in my WEBPAGE. Still i m getting the same error

I have put the function in the module. Option Compare Database Public Function ConcatRelated(strField As String, strTable As String, Optional strSeparator = ",") As Variant On Error GoTo Err_Handler 'Purpose: Generate a concatenated string of related records. 'Return: String...

Hey Thanks For Correcting me, It was a mistake when i was typing the forum.I checked out my function name n function name that i have passed in the query. Still not resolved .Still The same error *Undefined function Concat in expression*

Anywaz Thankyou... The error that i m getting is function expression not found

Thanks for the reply. I m new to access database.I have created the function in module and when i m trying to excute the query it is saying their is no contact function defined. Function concat(image1 As String) As String Dim mystring As String Dim rs As Recordset Set rs =...

Hi, I have a table Structure filename AKA 12-3-09.pdf 443567 12-3-09.pdf 345678 12-3-09.pdf 456789 3-3-10.pdf 78901 filename AKA I want to output as 12-3-09.pdf 443567,345678,456789 3-3-10.pdf...