Display all

Experts, not sure of the proper terminology of my question...apologies for my ignorance.  I know there is a techy term for my issue though.  

I have a report with the following:

="Business Owner: " & [BusinessOwner]

but my issue is that there is more than one assigned [BusinessOwner] and I want to show all of them.  

example BusinessOwners:
Tony
John

and "Business Owner: " & [BusinessOwner] will only show the first record "Tony" but I want to display Tony; John and basically any others that might be as a [BusinessOwner].  It would be similar to cycling through all BusinessOwners and returning all those names.  

thank you
pdvsaProject financeAsked:
Who is Participating?
 
Dale FyeCommented:
Check out the discussion of this topic on Allen Browne's website

Or on The Access Web

Both of these are great resources that I use as my 1st and 2nd stops on my search for a solution list.
0
 
pdvsaProject financeAuthor Commented:
Thanks guys... I thought it would have been simpler.  It is not a necessity but more of a want so I can do without it.  I will try a Dlist and Dfind and see what happens.
0
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
Dale FyeCommented:
Tony,

This is not that difficult.  The key is to copy one of the functions listed in those articles into your database.  

Then you need to have a table that contains the names of the Business Owner(s).  This should be a One-to-Many relationship to your Businesses table in order for this technique to work.

If you don't have that type of data structure, but have multiple fields in the same record for the BusinessOwners, then the syntax would be something like:

="Business Owner: " & [BusinessOwner] & (", " + [BusinessOwner2]) & (", " + [BusinessOwner3])
0
 
pdvsaProject financeAuthor Commented:
Thank you Dale...
0
 
pdvsaProject financeAuthor Commented:
Dale:

<Then you need to have a table that contains the names of the Business Owner(s).  This should be a One-to-Many relationship to your Businesses table in order for this technique to work.
fwiw:  the table I am working with is an import.  I do not have a separate table with all of the Business Owners.   I also do not have the structure like this:  [BusinessOwner] & (", " + [BusinessOwner2]) & (", " + [BusinessOwner3])

Would those methods work knowing that I do not have a separate table with [BusinessOwner]?
0
 
Dale FyeCommented:
Then how will you know if there is more than one BusinessOwner for each business?

Is this form based on this table that is being imported?

Does this table contain multiple records with the same BusinessID or BusinessName, with different values in the BusinessOwner field?
0
 
pdvsaProject financeAuthor Commented:
It is a report.  It is grouped per another similar field ExecutiveOwner.  It does contain multiple records per ExecutiveOwner and BusinessOwner is a another sub group.   There is not an ID other than the autoID that gets assigned when I imported.  

What do you think now?
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.