PeopleSoft Adoption Made Smooth & Simple!
On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool. Claim Your Free WalkMe Account Now
Function ConcatVar(sVar As Variant) As String Dim rs As DAO.Recordset, s As String Set rs = CurrentDb.OpenRecordset("select * From [Combined-Tax-Data] Where [LoanID]=" & sVar & "") rs.MoveFirst Do Until rs.EOF s = s & rs("[Tax_Explanation]") & ";" rs.MoveNext Loop ConcatVar = Left(s, Len(s) - 1) End Function
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
|Win 10 Automation Error with .doCmd in Access||2||81|
|I am having an ODBC timeout issue with an Access Frontend||6||54|
|How To Overlay Combo Box Row Source Type 'Value List' From VBA||2||46|
|Importing specific cell from Excel to MS Access||17||44|
Join the community of 500,000 technology professionals and ask your questions.