Access Report Grouping

[Teresa@BTMilner.com]

My database contains sales records. There are occasions whereby one unit could have 2 salespeople. In this case, each salesperson receives credit for .5 units sold.
I'd like for my report to list all units sold by a person whether that person be Salesperson 1 or Salesperson 2.
This image shows Salesperson 2 as a column under the group for Salesperson 1. I want to keep it here as a display, but also shown under the sales associate (Joiner in this case) where she is as Salesperson 1.

[llkhoutx]

Group your report by sales person.

[June7]

You have two fields for sales persons (Salesperson1, Salesperson2)?

[Teresa@BTMilner.com]

Salesperson 1 and Salesperson 2 are always different names. In other words, sometimes 2 different people are involved in selling a car. Both people need to get paid a commission. I'm trying to build a commission report for them both.

[June7]

So that was a yes in answer to my question?

If so, this is not a normalized structure. If you want the same record to display in the report under both persons, this will likely require a UNION query as the report RecordSource.

There can never be more than 2 salespersons per sale?

[Teresa@BTMilner.com]

There often WILL be 2 salesperson per sale

[June7]

Yes, but never will be more than 2? No need to allow for more than 2?

[Teresa@BTMilner.com]

There will never be more than 2 salespeople for a transaction.

[June7]

I guess it is confirmed there are two salesperson fields. My advice in post 5 still applies.