I truly @*#&^@# Access! just kidding!

[RHomarMAN]

okay where to start....

i have a table called saleslog
fields called repname (text)
amountsold (currency)
date (date)
newproduct (yes check box)

In a report I just want to show the amount sold and the amount sold of new products...

sales rep:Jack
number of new products: 5
amount sold new product: $500
amount sold total: $10,000
here is how i got the count of new products
=Sum([NEW/ PREV])*-1

what is the expression to get the $$ of new products sold?

 

[dhookom]

If you only want to show the aggregates by RepName then create a query with SQL like:

SELECT RepName, Sum(Abs(NewProduct) * AmountSold) as NewProdSales, Sum(Abs(NewProduct)) as NewProdNum, Sum(AmountSold) as TotalSales
FROM SalesLog
GROUP BY RepName;

Duane
Hook'D on Access
MS Access MVP

 

[RHomarMAN]

WOW thank you!

any way to do it as an expression for and existing report?

 

[dhookom]

In any group or report header or footer section, you can add a text box with a control source like:
[tt][blue]
=Sum(Abs(NewProduct) * AmountSold)[/blue][/tt]

Duane
Hook'D on Access
MS Access MVP