detail section in a report

hey all. i have a report for sales commissions that i'm having a little
trouble with. each transaction may have either 1 salesperson (90% of the
time) or 2 salespeople. in the event that there's 2, each of them get half
credit for the sale and half of the commissions earned. my problem is that
my report (rptcommissions) doesn't show the detail of each record if the
named salesperson is 'second' in this particular transaction.

to clarify, if john smith has a sale split with jane doe, each is considered
to be half a sale but john is the primary salesperson (field salesperson1).
in my report, it will list all of the records for john on page 1, including
this split sale. the problem is that for jane, it will list all of the
records where she was salesperson1 on her page, but i need it to also list
(seemlessly, if possible) the records where she is salesperson 2 and it
doesn't do that.

i understand that it's because my report is grouped by the salesperson1 field,
but i don't know how i can show the detail for any back-half split sales.
i'm still green when it comes to access so let me know if i left out any
needed info to figure this out. thanks

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/databases-ms-access/200512/1
.

Relevant Pages

  • Re: Report in Access97
    ... "John Spencer" wrote: ... Select the fields SalesPersonNumber, Sale Amount ... Enter the following in the next field block, ... salesperson, total collected per salesperson, and percentage collected per ...
    (microsoft.public.access.reports)
  • Re: detail section in a report
    ... each transaction may have ... > sale and half of the commissions earned. ... > my report doesn't show the detail of each ... > salesperson. ...
    (comp.databases.ms-access)
  • Re: formula help, sorting information
    ... Make the Salesperson a Page Field, then you can get a report for each ... Saleperson on a separate sheet. ... > each sale to a salespersons sheet and the new or used tally sheet ...
    (microsoft.public.excel.worksheet.functions)
  • formula help, sorting information
    ... reporting sales. ... corresponding salesperson and reported in a new or used tally sheet. ... What would be perfect is if there is anyway I can easily send each sale ...
    (microsoft.public.excel.worksheet.functions)
  • Re: what constitutes the open and close date when we purchase an option, excercise it, then buy/sell
    ... when we purchase an option, excercise it, then buy/sell shares to close ... So how to report this on ... I question the wisdom of entering into a short sale just to ... the sale price would be the amount of the transaction on date D2 ...
    (misc.taxes)