Link to home
Start Free TrialLog in
Avatar of TIgerV
TIgerVFlag for United States of America

asked on

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?
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
"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.
Avatar of TIgerV

ASKER

Thanks for the quick answer!