calculation fails

I have a strange problem with a calculation. It seems to be working
for most "rows" in my table, but one set of rows fails, and I can't
figure out why. Can someone help me troubleshoot? Here's the set up.

I have two tables. The first, called COURSE, has two fields: Course
and Credit. The latter field lists the number of credits a student
earns for taking the course in Course. The Course field is related to
the Course field in another table. This second table, ALL, has a field
Students that stores the number of students. It also has fields for
Semester and year. What I want to calculate is the number of credits
generated by each course each semester, so I use a calculation field in
the ALL table that looks like "Students*COURSE::Credit". For every
course but one, this gives me the correct number, but for one course, I
get nothing. No number. When I fiddle with the course information in
the COURSE table (change the number of credits, reenter it into the
table, etc.) nothing happens. When I delete the row in COURSE that
defines that course, nothing changes, either. What could be going
wrong?

Thanks for whatever advice people can share. I know it's probably a
dumb question, but none of my references are any help.

.

Relevant Pages

  • Re: Precision issue with Float and Double (C++)
    ... If the error is "significant enough to affect my calculation" then your calculation is not ... predates that of "Windows programming" ... In the year when students across the channel were revolting and tearing down their universities, I was learning to write programs to invert 20x20 matrices using fancy numerical methods in FORTRAN. ... Anyway: first instruction: call everything REAL*8. ...
    (microsoft.public.vc.mfc)
  • How do I set conditions to stop calculations?
    ... I have a database that tracks dates for students who transfer. ... to do is stop the calculation once they actually leave from the current ... "Total Days", "Status"(a pulldown listing ...
    (microsoft.public.access.gettingstarted)
  • RE: formula in word
    ... Make sure you start the calculation with = or it won't work. ... > Column Cand subtract any credits that appear in Column ... >> your table cells labelled as they would be in Excel i.e. ...
    (microsoft.public.word.tables)
  • RE: How do I automatically select a Excel record randomly?
    ... When I step thru the calculation steps, I am only seeing the calculations for ... "Teethless mama" wrote: ... I have an Excel file / database of students who have taken an examination. ... an examination score of 85% or higher. ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Going back to School
    ... > and Mike is working on his Associates of Science with a pre-nursing major. ... > We don't dare go below 12 credits as it will affect our legibility for our ... > credits and Mike is carrying 12, which is the minimum for a full time ... first semester, although many students do. ...
    (rec.pets.cats.anecdotes)
Loading