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?

[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.

Dale FyeOwner, Developing Solutions LLCCommented:
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

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
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
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Dale FyeOwner, Developing Solutions LLCCommented:
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 FyeOwner, Developing Solutions LLCCommented:
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
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.