Concatenate function not working

[Kayleigh]

Hi,
Trying to join together several related records into one textbox - used the very useful function I found on this post and associated code.
However I keep encountering errors when running.
Can anyone suggest where I went wrong please?
Thank you
Krayna

 

[Kayleigh]

see Query1.

That's great but how would I have each date on a new line?

 

[arnelgp]

where is the date coming from?
there is another table in your sample but no connection to StudentID?

 

[Kayleigh]

Did you read post #13 where I explained that the studentAttendance records the students who attended sessions which were logged in sessionLog. So the date of session are in sessionLog and registerCode is in studentAttendance table.

 

[theDBguy]

Thanks. I understand but not sure how to apply to my situation - would like join related rows by date.
I've copied relevant part of form to DB so you see how it works.

Sorry, that doesn't really help me understand what you want, but I gave it a try anyway. Hope this helps...

 

[Kayleigh]

Thank you! I was really looking to replace the Code column in the listbox with the concat function to reduce number of rows by having each date displayed once only.

 

[theDBguy]

Thank you! I was really looking to replace the Code column in the listbox with the concat function to reduce number of rows by having each date displayed once only.

Hope this is close to what you want...

 

[Kayleigh]

Yes just integrated into my DB and it shows correct info. Only trouble is its slow to load because must sort through large dataset to find related records. Any way to avoid this?

 

[theDBguy]

Yes just integrated into my DB and it shows correct info. Only trouble is its slow to load because must sort through large dataset to find related records. Any way to avoid this?

For large data sets, it's possibly better to run an initial make-table query for all the data your form needs.