query total

[vanguardaccess]

I have what may be a simple question, yet I can't figure this out. Any help
would be greatly appreciated.

I have a table, for example, with the following fields and data:

ID---YEAR---TERM---COURSE---DEPT---MARK
0001---2007---01----ALGEBRA---MATH---75
0001---2007---02----VIETNAM---HISTORY---85
0002---2007---02----ALGEBRA---MATH---90
0002---2007---02----VIETNAM---HISTORY---50

I want to create a query that finds the percentage of courses passed (mark

64) in each department and for each year/term.

How can I do this? I am stuck. Thank you very much.
--vanguardaccessman

 

[Fred]

I noticed that nobody answered.

The only way I know how to do that would be a report. Group by whatever
you wnat to summarize, than then a summary expression for the group something
like:

= sum(iif([mark]>64,1,0))/count([mark])*100

 

[vanguardaccess]

Thank you, I really appreciate that, and it will be useful. However, I'd
like to create it as part of a query so that I can show the results in a
pivot table and chart. Any help with that would be greatly appreciated.
--
--vanguardaccessman

I noticed that nobody answered.

The only way I know how to do that would be a report. Group by whatever
you wnat to summarize, than then a summary expression for the group something
like:

= sum(iif([mark]>64,1,0))/count([mark])*100

I have what may be a simple question, yet I can't figure this out. Any help
would be greatly appreciated.

I have a table, for example, with the following fields and data:

ID---YEAR---TERM---COURSE---DEPT---MARK
0001---2007---01----ALGEBRA---MATH---75
0001---2007---02----VIETNAM---HISTORY---85
0002---2007---02----ALGEBRA---MATH---90
0002---2007---02----VIETNAM---HISTORY---50

I want to create a query that finds the percentage of courses passed (mark

How can I do this? I am stuck. Thank you very much.
--vanguardaccessman