Mehrdad

Thank you very Much, I don't know how to thank you.I am greatful

Please See the attached file to see what I am trying to do. I really appreciate your time. schoolListOld.zip

I made a calculation field called REPORT and put this in calculation option If( ID Due Date & Pims Due Date < (Today),1,0) And made sure "do not calculate when the field is ematy is selected. However when I go to browse mode all Overdue and blank field are 1 and the rest 0 why is this happening although I ask FM not to calculate when field is empty? Is this happenning because my due date are calculation from Shoot date?

I am sorry Mine doesn't work, I think it might be where you mentioned to put If [ not Status(CurrentFoundCount) ] Should I choose the If from the menu and write not Status(CurrentFoundCount) ] in there or I am getting confusesd here because when I leave the IF there it gives me error when I take the IF out it look like this when I close the calculation If [ "not Status(CurrentFoundCount)" ] In any case it brings up noting but it doesn't say record not found either.

you are right if I don't know what is insert calculated result I must be a beginner. I did everything you mentioned but It always comes up with no overdue record found, although I have 2 over due records. I don't know if I mentioned before that in each record I have at least 10 to 15 field which have different due dates. Can I ask for different fields or is this calculation good for finding overdue date in one field in all records. I do really appriciate your help and response. thanks

I am sorry, you lost me on (Insert calculate result) would you elaborate a bit more. I wish I could email you my file, so not to take anymore of your time and you could see what kind of mess I am in.

Thanks for your response, I do have fields that calculate the overdue dates however there are lots of them in my database. Is there anyway to find those overdue items without having to type overdue in each field?

We have photography studio which photograph students in schools. I have made a database which has a photo shoot date and every service we give to schools such as Rolodex cards and yearbook CD have a due date that must be back to schools on those dates. I need a report that can create a Due date and Overdue date so my staff can get on it right a way. when I made a report layout it asked me for the field I need and I pointed to (School name, YB CD and Rolodex Cards and so on) But when the reports were generated they have all the schools and all the services, I need an action or script that will bring only the Overdue schools and their Overdue items. How can I create such report.