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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.