Calculate Fields

[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!

 

[Duane Hookom]

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;

 

[John W. Vinson]

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!

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).

 

[Jeff Boyce]

Is this a question about using MS Access? This newsgroup supports queries
in MS Access.

Regards

Jeff Boyce
Microsoft Office/Access MVP