Calculated Field not showing

[imintrouble]

Hello.



In my table, which I have been using for about five months, I have been importing excel files into it, 6 so far. Included in this table are a number of fields which are caluclated, taking the information from other fields like 0, 15, 9, 3...etc and then deciding on what answer should populate the field through an IFF statement. This has worked splendidly so far. Then, just this morning, I imported a 7th excel file into the table. It all looked fine, except when i went to make sure that the numbered fields from before were not populating the caluclated fields AT ALL. Because the other groups 1-6 above this were still calculated, I determined it was not the codes fault, at least directly.

Are there any possible answers to this. I would have looked it up in Google, however I dont even know what to search for.

Thanks.

[imintrouble]

Update on this, I tried entering a number myself into one of the fields which the other caluclated field gets its info from, so i entered a 0, and out popped the correct answer where it was supposed to be. So i went ahead and re-entered the other numbers again manually, and it worked, not sure why this happened.

Anyways, if anyone has any idea why this happened in the first place, i'd be willing to listen.

[RayMilhon]

Which is why I've never found a good reason to include a calculated field in a Table.