Re: Report in Access97

I'm not quite sure I know what I'm doing, can you be more specific? haven't
done much at all with formulas, so it's confusing to say the least. do i
need to insert a column in the query? i tried using the info you gave me, but
it would say i had too many or to few ( ) [ ] (i tried different ways to what
you gave me).

"John Spencer" wrote:

Use a query that looks like the following:

SELECT SalesPersonNumber
, Sum([Sale Amount]) as Sales
, Sum(IIF(Paid,[Sale Amount],0) as Paid
, Sum(IIF(Paid,[Sale Amount],0)/ Sum([Sale Amount]) as PercentCollected
FROM [Your Table]
GROUP BY SalesPersonNumber

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

labtyda wrote:
I am trying to create a report with the following: total sales per
salesperson, total collected per salesperson, and percentage collected per
salesperon. data base has sale amount, date paid, paid (yes or no)
salesperson number (others too, not pertinent to report) any suggestions??

.

Relevant Pages

  • Re: Employed or Not!!
    ... Person works as a salesperson, he is paid commission, but in order to ... cheque on the invoice that he has raised, ...
    (uk.legal)
  • Employed or Not!!
    ... Person works as a salesperson, he is paid commission, but in order to ... cheque on the invoice that he has raised, ...
    (uk.legal)
  • Re: Employed or Not!!
    ... Person works as a salesperson, he is paid commission, but in order to ... cheque on the invoice that he has raised, ...
    (uk.legal)
  • RE: Dates in a Query
    ... Field names are: Salesperson ... $80 pledge date 1/2 paid-no ... Here is what I have for fields: Pledge date, Sale Amount, Paid ...
    (microsoft.public.access.reports)
  • Re: Report in Access97
    ... , Sum([Sale Amount]) as Sales ... salesperson, total collected per salesperson, and percentage collected per salesperon. ... data base has sale amount, date paid, paid salesperson number any suggestions?? ...
    (microsoft.public.access.reports)