Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Putting rows into one field..,. 1

Status
Not open for further replies.
vanillapod

vanillapod

MIS
May 9, 2000
446
GB
If i have rows from a query throwing out staff names is there a way to put those names that meet a criteria into a single field separated by a coma or something?
Cheers
 
Sort by date Sort by votes
I have a sample db that I could send you if you provide your email address. It demonstrates a function that returns a delimited string based on rows in a report.

HTH Joe Miller
joe.miller@flotech.net
 
Upvote 0 Downvote
Thanks Joe that'd be great my email is:

vanilla_pod@hotmail.com

Cheers
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

breezett93
  • Locked
  • Question
What should be multiple reports is becoming one report with multiple pages 1
Replies
13
Views
346
dhookom
dhookom
iamchemist
  • Locked
  • Question
Write a value into an unbound text box in a Report
Replies
3
Views
227
dhookom
dhookom
lameid
  • Locked
  • Question
#Type! using replace on Long text field
Replies
4
Views
356
lameid
lameid
lameid
  • Locked
  • Question
Get a named Field Value from Report via function call in Report Control source.
Replies
3
Views
194
dhookom
dhookom
puforee
  • Locked
  • Question
Fields moving when report opens - only on one computer
Replies
1
Views
169
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top