Counting

[Rusty]

Hello,

I have a query and I know this is easy but it's Monday morning here and my brain is yet to kick in.

I have a query with:

[Name of Trial]
[Status]

I need to add up all patients in [Status] grouped by [Name of Trial]

…easy enough I can do that, but I want another field that adds up all patients in [Status] with a value of "follow up" grouped by [Name of Trial]

Any ideas? I'm counting on you guys…(pardon the pun)

 

[Pat Hartman]

See if this totals query gives you what you need. It will produce a row for each different status value. If you want to limit it to just the two you mentioned, add selection criteria.

Select Status, Count(*) As StatusCount
From YourTable
Group By Status;