calucalte for report

[mathanraj76]

Hi ..
I have report which i need calculate for those product and show by count and sum
I have done for those product but

1.I need know how many product "X" in my database
For an example let say if in my database i have 10 product "X" then it show me 10 product X in my report summary


2.I need know how many "Agency" and "Direct Client"
3.I need know how many "Local" and "Overseas

I have attached sample database.

Thanks
Mathanraj

[June7]

You want to know how many of those entities are in the tables?

Could try:

DCount("ID","[tblDirect Client]")

DCount("*","[tblmagazine]")

If you want to know how many in the report, try:

Sum(IIf([Client(Agency/Direct)]="Agency",1,0))

[mathanraj76]

Thnks

you solved my problems... tht's wht i want ..
your code always perfect for me..
thnks
Mathanraj