Average 2 fields and round up.

K

Kevin Sinclair

OK, here's what I am trying to do. I have an Access 2000 database that
contains student information, including grades. We have 1st Quarter Grade,
2nd Quarter Grade, 1st Sememster Grade, 3rd Quarter Grade, 4th Quarter
Grade, 2nd Semester Grade, and Final Grade. What I would like to do is have
the system calculate the 1st Semester, 2nd Semester, and final grade. What
needs to happen for 1st Semester Grade is "1st Quarter Grade + 2nd Quarter
Grade / 2" then if the grade is something .5 we need to round up. I know how
to do the averaging in a query using the expression builder. Is the rounding
possible in Access? I also looked at trying to do a VBA module but got in
way over my head.

Does anybody have any advice?

Thanks.

Kevin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Template with fields and premade texts.. 0
calculating average handling time 7
Random number generator 1
Mail Merge Help 1
Selecting top 2 records on same row 4
InStr - to lookup exact match 4
Querying results for two recent dates 3
Select/Delete Sheets 5

Top