Relationship / calculation problem

[Sergeant Ron]

Not quite sure how to categorize this, but here goes. I have two separate databases (Files). One has a summary field that is put into a calculation to add it to another summary field and give a total. This works fine and displays the correct number. I also have another file that needs that data on a monthly basis. I have a relationship set up that uses a field in each database called cMonthYear (which is a calculation of

MonthName ( date ) & " " & Year ( date ) . This also appears to work fine with one exception. The one field that is used in the first database gives me a correct result in the native file but 1 less in the related file. even if I drag and drop the field from one database to the other its still one less. I have no idea why this is happening??? anyone have a suggestion?

Thanks,

Ron.

[Sergeant Ron]

Nevermind folks. I figured it out. The calc of cMonthYear wasnt entered on one record, thus throwing it off. Whew... Thanks anyway.

Ron

[T-Square]

Since you spent an hour wondering at this, you might want to figure out how this happened, and alter your design to prevent it in the future...