comma delimited report, query or form

I keep track of member numbers as people come into a meeting.  (They scan their membership cards).
[tbl_meeting_attend] keeps the date, and member number.

As soon as the meeting is over, I need to upload a list of all members, in comma delimited format, into the company safety system.

Can I run either a report or query that just displays on the screen the comma-delimited list of attendees, so I can copy-paste them into the safety system website?
Who is Participating?
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
So your "tbl_meeting_attend" contains multiple rows, and each of those rows has a "member number" field, and you need a comma-separated string of those members?

If so, you could create a small form with a Textbox (txUserList) and a Button (cmGetUsers). In the Click event of cmGetUsers:

Dim rst As DAO.Recordset
Set rst = Currentdb.OpenRecordset("SELECT [Member Number] FROM tbl_Meeting_Attend WHERE CLAUSE HERE IF NEEDED"

Dim s As String
Do Until rst.EOF
  s = s & "," & rst("Member Number")

If len(s) > 0 then
 Me.txUserList = Left(s, Len(s)-1)
End If

You could then copy the contents of the Textbox and do what you need with it.
"Comma delimited format" typically means .csv file.  Is that what you are asking how to do?  Because that statement conflicts with "copy-paste them into the safety system website".

To create a CSV file, create a query that selects the list of members who attended today and export it manually by right clicking on the query or use TransferText to automate the export.
TIgerVAuthor Commented:
Thanks for the quick answer!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.