Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

RHomarMAN

Technical User
Joined
May 15, 2008
Messages
2
Location
US
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?
 
If you only want to show the aggregates by RepName then create a query with SQL like:

Code:
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
 
WOW thank you!

any way to do it as an expression for and existing report?
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top