Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by ninepro
-
Concatenate HELP!!!
Guys, Absolutely awesome worked like a charm, one last thing is there any reason that the <div> tags are visible in the query results for the comments field? Jason...- ninepro
- Post #9
- Forum: Microsoft: Access Queries and JET SQL
-
Concatenate HELP!!!
Ok, I have taken the FROM out and the following error appears: The SELECT statment includes a reserved word or argument name that is mispelled or missing, or the punctuation is incorrect. The query is now: SELECT Calls.ID, Calls.Title, Calls.[Opened By], Calls.[Opened Date], Calls.[Resolved...- ninepro
- Post #5
- Forum: Microsoft: Access Queries and JET SQL
-
Concatenate HELP!!!
Hi, I have the function added and have included the following in my daily report query from the main calls table: Comments.Comment, Concatenate("SELECT Comment FROM Comments WHERE IssueID =" & [IssueID]) AS Comments The field comments is now added to the query results for each ID in the...- ninepro
- Post #3
- Forum: Microsoft: Access Queries and JET SQL
-
Concatenate HELP!!!
I have attempted most of the Concatenate FAQ's on here and nothing seems to work. I have a existing query which I run from a my calls table which produces a daily report for each day, however, I have now created another table to store comments which are linked by issue id to the main table and...- ninepro
- Thread
- Replies: 9
- Forum: Microsoft: Access Queries and JET SQL
