count selected fields in a query

  • Thread starter Thread starter Ra
  • Start date Start date
R

Ra

In Query1 I have two fields:

CurScore ReqScore
1 2
0.5 3
2.5 1
3 2.5

I would like to create a third field (NewScore) where I count just the
values from CurScore > ReqScore

Any help would be greatly appreciated
 
Not quite sure what you want

Perhaps

Field: GoodStuff; IIF (CurScore > ReqScore, 1, 0)

Or if you just want a count of GoodStuff
FIELD: GoodStuff: Sum(IIF(CurScore > ReqScore, 1, 0))


John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
 
Thank you so much....this is what I needed.

John Spencer said:
Not quite sure what you want

Perhaps

Field: GoodStuff; IIF (CurScore > ReqScore, 1, 0)

Or if you just want a count of GoodStuff
FIELD: GoodStuff: Sum(IIF(CurScore > ReqScore, 1, 0))


John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
Click to expand...
 
Back
Top