Importing problem with calc fields

[Leiper's Fork]

I have a database that has several calulating fields. After importing several thousand records, I cannot get the new records to calculate. If I manually add a record, the calc fields work fine. Anybody have any answers for me?

[Leiper's Fork]

OK. I solved the mystery. My calualting field is a text field. All of the fields in the calculation are also text fields. One of the text fields used in the calculation had an extra 15 spaces at the end of the text. When I delete the spaces, the calculating field works fine. Don't ask me why. It's all very strange. But if someone else encounters this problem, now you know the rest of the story.

Edited March 21, 2006 by Guest