This bug is very strange:

I have 5 different views for an entry form i made. and I have a total
column to count total entry for each view.

I usually open this database in another window when enter data in the
form.

I have used this newly designed database for couple of days. Then I
realised the sum in each views are different. As I realise, the total
entries in these 5 views are all different. Some of them missing in
one view while some of them missing in the other.

Then, I tried to re-save all the entries again in the main window,
finally the totals come to an equal number. But I still cant figure
out why could that happen.

Has anyone had this problem before. It will be very helpful to share
some of your experience.