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?
TIgerVAsked:
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")
  rst.MoveNext
Loop

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.
0
 
PatHartmanCommented:
"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.
0
 
TIgerVAuthor Commented:
Thanks for the quick answer!
0
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.