Number field data disappears

[technoranger]

I have a simple database with 12 billable days fields (Number field), one for each month. That field is used by other fields for calculations. The problem is the data in the billable days fields often disappear. I say often because it does not happen all the time and it seems almost if it is entered often enough it sticks. These are the only fields in the database that this happens to.

Any ideas??

Rick

[Kurt Knippel]

Well, you left this WIDE open.

Initial guesses: poor planning has made it so that this is the outcome that is expected, although it is not what you desired; malicious users are deliberatly deleting the data; users are inadvertantly deleting the data; gremlins have invaded your systems and have chosen this as thier modus operandi.

Much more information is needed before any real evaluation can be done. Such as the kinds of fields involved; how you have this database setup and how do you use it; is this one record file or does it have multiple records; what do these records represent; etc.

[technoranger]

All right....I'm the only user so, unless we have a psychosis we are unaware of, scratch malicious users.

The number fields are plain vanilla. The file has multiple layouts and a small number of records (15 - 20). At the end of each month I enter the number of billable days for that month (July has 18 for example). I have a contract to serve 15 people per billable day. If I am full for July, that is a total of 270 units. On another layout I have individual records for how many days each person used, reported in number fields. There is a summary field that totals those days used.

To keep track of whether I can carry over days from one month to the next, I need to know how many of the 270 units I've used, so I have a calculation field that multiplies the original number of billable days (18 for July) by 15 and subtracts the summary total of individual days used.

The underlying problem is the data in the original number field often simply disappears so I end up multiplying 0 by 15 then subtracting a summary total (270) and carrying over -270 days.

So.....any ideas on what could cause number field data in a database only I use to sporadically disappear - sometimes when I switch between layouts?

Rick

[trevorg]

Maybe it's possible that when you think you are entering data into a new record, you are actually in find mode? It would appear that you are entering new records, when in fact you could be entering new find requests. Then, when you switch layouts, (if done by scripts), it might be flipping you back to browse mode. Viola! Records mysteriously disappear!