Whats the point of queries...

[Simon_MT]

So not much is changed except:

iif([Live] = "Live",Count([ID])) as CountofLive
iif([Live] = "Closed",Count([ID])) as CountofClosed
iif([Live] = "Won",Count([ID])) as CountofWon

Simon

 

[boblarson]

Or an alternative these three separate columns:

CountOfLive: Sum([Live]="Live", 1, 0)

CountOfClosed: Sum([Live]="Closed", 1, 0)

CountOfWon: Sum([Live] = "Won", 1, 0)

 

[jonathanchye]

I've found the easy way around this. I've decided to create 3 separate subreports and then "merge" them in one main report. By doing some basic formating I've got the report to look the way I want it to be and its way faster than using DCount

Maybe I have lots to learn about using Queries appropriately. Well, at least for now I've got one problem out of the way.

 

[Simon_MT]

Thanks Bob. This is a do-able problem and what I was trying to do was a step-by-step approach because if you work out the how-to, you will really appreicate what queries can do and how powerful they are.

Simon