By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,851 Members | 1,183 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,851 IT Pros & Developers. It's quick & easy.

Concatenate Records into One Record

P: n/a
Bear with me since I know very limited knowledge about VBA and
Module...

I have a table Employees, where I build a query out of based on
TeamID=1, Therefore, only listed those employees that belong to Team1.
Now, I want to somehow concatenate all those employees in Team1 into a
single field on a form or Query or something.

I have searched thru this Forum and found many good advice, however,
they are not for beginner like me. They don't specify where to put the
codes... in the form itself? in the module? (then how do I call up the
module?)

e.g. where do I put these codes?

http://www.mvps.org/access/modules/mdl0008.htm

I assume put it in the module, right? Then how are module being
called/used in a Form?

Thanks in advance.

Perry

Jul 13 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Can I ask _why_ you want to "concatenate the employees into a single field"?
If you use your Query as the RecordSource for a Form in Continuous Forms
view, you can scroll through all the employees, and you won't have to do
much of anything. Further, there's a wizard for creating a ComboBox, so you
could create a Combo Box to select which Team you want to display.

Larry Linson
Microsoft Access MVP
<pe******@yahoo.comwrote in message
news:11*********************@35g2000cwc.googlegrou ps.com...
Bear with me since I know very limited knowledge about VBA and
Module...

I have a table Employees, where I build a query out of based on
TeamID=1, Therefore, only listed those employees that belong to Team1.
Now, I want to somehow concatenate all those employees in Team1 into a
single field on a form or Query or something.

I have searched thru this Forum and found many good advice, however,
they are not for beginner like me. They don't specify where to put the
codes... in the form itself? in the module? (then how do I call up the
module?)

e.g. where do I put these codes?

http://www.mvps.org/access/modules/mdl0008.htm

I assume put it in the module, right? Then how are module being
called/used in a Form?

Thanks in advance.

Perry

Jul 13 '06 #2

P: n/a
Larry,
Sure, the reason why is to combine a certain groups of employees
into 1 field and use it as a record source table for users to choose
from (drop down list).

Perry

Jul 13 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.