I have two tables: One stores appointments (Appts), the other stores info on people (People). Every person has appointments that are due at regular intervals, so I have a number of calc field in People that calculate each due date based on a field initial_date. I then have a number of fields that calculate whether an appointment is within 5 days of being due and has not yet been scheduled (e.g. appt1Due, appt2Due, etc.). These calcs return 1 if criteria applies and "" if it doesn't.

I might add that there are a number of relationships in play here for each type of visit, but all with the same general format. The two tables link by peopleID and apptType.

The problem I'm having is that when I do a find and try to find all the people that have 1 in, say, the appt1Due field I get wierd results. The fields themselves display the correct results, but the find comes up with records that are blank as well as ones that have 1s in them. Can anyone help me figure out what is going on? Thanks.

asaw->

Welcome to the Forums!

On general principle, make the calcs return 1 or 0, not 1 and empty. How do you do the find? I suspect that the way you're doing it is including records with the field empty.

Did you ever find an answer to this problem? I'm having a similar issue where the calc field is returning correct results... but when I do a FIND, it comes up with seemingly random records.

On a sidenote, this database is being shared over a network. I'm on a remote machine. I discovered that the machine that's hosting the file comes up with the correct results when doing the same FIND.

Any ideas?

DYL