I have a number of tables (i think 3 in total) with vaious data in them, mainly to do with attendance. I have them all linked up joined on an ID field which is unique to each person) so that i can gather data from all 3 tables.

The problem is when i try to use a formula with values from one of the tables. Some of the IDs are not in this table (as this one is the persons attendance at a different site and so some have not gone there) and so the moment i put this formula into the report the IDs of the people that are not in the table disappear and i cant see why.

I've tried changing the report links between the tables and so on but nothing i've done works. Can anyone suggest something i can try?

Oh and i've found that i cant put all the data into a single table as when i use the formula it brings back the wrong value. I'm guessing its something to do with the links or something but i just cant think what it could be

 

Thanks for your help

Any help is appreciated