Concatenating Query Results

[GendoPose]

Hi All,

I have a query that I want to concatenate some of the results onto a single row, but I'm having trouble.

I've followed Allen Browne's example, but when I run the query, I either get the #Type, #Name or a 3201 error (I believe, I can't recreate it now).

I'm pretty stuck on what to do next, if you can help and need more information then please ask and I'll post what I can.

Thanks.

 

[pr2-eugin]

#Type error normally occurs when you are trying to logically equate two incompatible types like Number = String, Boolean = String or something like that.

#Name will come up when you are referring some controls/fields incorrectly or wrongly spelt.

Either of which is highly possible when you are using Allen Browne's - ConcatRelated method. It is not possible to give a specific solution without checking the code !

 

[GendoPose]

#Type error normally occurs when you are trying to logically equate two incompatible types like Number = String, Boolean = String or something like that.

#Name will come up when you are referring some controls/fields incorrectly or wrongly spelt.

Either of which is highly possible when you are using Allen Browne's - ConcatRelated method. It is not possible to give a specific solution without checking the code !

If I upload the database, would you mind showing me how to fix this? That's definitely helped, but I'm still not managing to get it right

 

[pr2-eugin]

Okay, To create a Sample DB (to be uploaded for other users to examine); please follow the steps..

1. Create a backup of the file, before you proceed..
2. Delete all Forms/Queries/Reports that are not in Question (except the ones that are inter-related)
3. Delete auxiliary tables (that are hanging loose with no relationships).
4. If your table has 100,000 records, delete 99,990 records.
5. Replace the sensitive information like Telephone numbers/email with simple UPDATE queries.
6. Perform a 'Compact & Repair' it would have brought the Size down to measly KBs..
7. (If your Post count is less than 10 ZIP the file and) Upload it..

Finally, please include instructions of which Form/Query/Code we need to look at. The preferred Access version would be A2003-A2007 (.mdb files)

 

[GendoPose]

In frmsubUsers - Current Bands, I'd like the Genres textbox to be the concatenated field (currently it's Unbound as I deleted the faulty controlsource).

Thanks