Access Report Calculation

  • Thread starter Thread starter Pilgrim_828
  • Start date Start date
P

Pilgrim_828

I have a report displaying students grades. The grade range is A to G and is
displayed in field ‘artFin’ : the following seven fields then look at
‘artFin’ and display either a numeric 0 or 1 in either field A, or field B,
or field C etc. By converting the alphabetical grades to single numeric
values I can work-out averages for individual students and classes. I’m
having a problem composing the formula to look at ‘artFin’ and return a ‘1’
or ‘0’ to each of the following fields after ‘artFin’
Pilgrim_828
 
Pretty rough description but assuming you want FieldA to be "1" if artFin =
"A"
Then set FieldA as "=IIF(Me.artFin = "A",1,0) and so on for the rest of the
fields

Regards

Kevin
 
Thanks very much for your swift reply with this, it worked a treat, I am very
grateful
 
Back
Top