Calculate Fields

  • Thread starter Thread starter CourtneyH
  • Start date Start date
C

CourtneyH

I have a spreadsheet with test scores and need to calculate the total number
of passing scores per subject area. Is this possible?

A passing score is between 400 and 600. Therefore, if a student has a score
of 452 for his Writing test and a score of 515 for his Reading test, I need a
value of "2" returned in a separate column for the total number of English
tests passed.

Thanks!
 
It's near impossible to answer without guessing your table structures.
Generically, if you tables are normalized, your query might look like:

SELECT StudentID, Count(*) as NumOfPasses
FROM tblScores
WHERE Score Between 400 and 600 AND SubjectArea ="English"
GROUP BY StudentID;
 
I have a spreadsheet with test scores and need to calculate the total number
of passing scores per subject area. Is this possible?

A passing score is between 400 and 600. Therefore, if a student has a score
of 452 for his Writing test and a score of 515 for his Reading test, I need a
value of "2" returned in a separate column for the total number of English
tests passed.

Thanks!
Click to expand...

Is this in fact a Spreadsheet (in Excel)? or a table datasheet (in Access)?

If you're working in Excel, I'd suggest that you repost in an Excel newsgroup.
Access and Excel are different programs with different techniques.

If you have a Table (which is *NOT* a spreadsheet, however much it looks like
one) in Access, please post a description of the structure of the table
(fieldnames and meanings).
 
Is this a question about using MS Access? This newsgroup supports queries
in MS Access.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top