Recent content by JRJohnson4

plog, Thank you for all of your help. I did what you suggested and it worked like a champ. I figured that it was probably something pretty simple that I was overlooking. Thanks again for your help and have a great day. I am off to start working on the next database project that I need to...

I am actually working with your suggestion now and trying to see if I can get the right totals based on the data That I ran a number of calculations on for a specific date range.

plog, If I wanted to determine the Sum of 30 Days Post Procedure Stroke, then I know that the expression would be: Sum(IIF([P4P / Goals]![30 Days Post Procedure Strokes]=True,1,0)) But the problem that I am having is that I need the Sum of 30 Days Post procedure Strokes based upon the...

I have built a query called "Carotid Reports - Symptomatic (Totals) 1" that gives a Sum of the following fields: CS CS Carotid Symptomatic CE CE Carotid Symptomatic 30 Days Post Procedure Stroke 30 Days Post Procedure Death In addition, this table only calculates the totals for these fields...