ContributionsMost RecentMost LikesSolutionsHow to write a formula that returns "Task Ovrdue" if a task is beyond (X) days HI, Thanks in advance, How do I write a formula that returns a "Current" or "Overdue" based on a field that tells how many days that task has to be performed and it has a Max activity date summary field, and a "Activities Due Every (x) Days" field. Today()-[Max Activity Date]>([Activities Due Every (x) Days]),"Current","Activities Due")) That was the best I could figure out. Thanks again ------------------------------ Bob Faulk ------------------------------ Summary Field Problem not giving me accurate info I run a clean & sober housing program where we have 28 houses with over 250 people living in our houses. Our parent table is Houses, the child table is "Beds". We have a summary field called "arrivals" that tracks the "Minimum bed start date" of people coming into our houses and another summary field called "departures" that tracks the "Maximum bed end date". The problem is we also have people that move from house to house sometimes and even within a house from bed to bed. I'm trying to find the number of actual arrivals and departures in our program by house, not the actual program. A person can move from house A to house B and not leave the program. A person can also move from bed 1 to bed 2 within the same house but that person may not have arrived in our program in that house at all. The person may have arrived in our program 1 or 2 houses ago, moved around within different beds in that house, left that house and moved to the new house, moved around that house x # of times and then departed our program. Each time a person arrives and becomes an owner of a "Bed" in our beds table, that record has a start date and end date when its closed. This gives us the history of the bed in the house but I cant figure out how to track the actual arrivals and departures because even though we may have a person start a bed then leave a bed on specific dates, that person may still reside in the house just in a different bed so my summary field is tracking an arrival and/or departure when the person may actually still be in the house. What can I do to get the correct numbers filtered through my summary fields. I have several summaries that I need I.E. arrivals last 30 days, last qtr, qtr 3 and qtr4 as well as departures for last 30 days, last qtr, qtr 3 and qtr4 as well. Thanks ------------------------------ Bob Faulk ------------------------------ Re: How to create a field that provides the recent user log infoSo if I add that to my formula... Trim(Left([my update field],"]")) What does that look like? ------------------------------ Bob Faulk ------------------------------ Re: How to create a field that provides the recent user log infoI have another question...How to I take that date I extracted and now turn it into the number of days from that last contact to today? ------------------------------ Bob Faulk ------------------------------ Re: How to create a field that provides the recent user log infoJust figured it out... Trim(Left([my update field],"]")) Thanks again! ------------------------------ Bob Faulk ------------------------------ Re: How to create a field that provides the recent user log infoHi Mark, Thank you. The formula works but its returning the oldest note stamp instead of the most recent. Also I used this formula... Trim(NotLeft(Left(Right([my update field],"["),"]"),9)) and it also cut off the date which is something I needed so I went to this and at least it gave me the date even though I still need the most recent entry but here it is... Trim(Left(Right([Call Notes],"["),"]")) What should I change to get the most recent? ------------------------------ Bob Faulk ------------------------------ How to create a field that provides the recent user log infoHow do I create a formula that will retrieve the most recent user and date log out of a notes field and put that in a separate field so we can see who was the last one to communicate in the notes and the date? ------------------------------ Bob Faulk ------------------------------ Re: Summary fieldsLOL, whats the chances of finding a thread on a question you had being the same one I had for a different problem!! ------------------------------ bob1coolguy bob1coolguy ------------------------------ Re: Form filling without internet connectionDo you know anyone that can create that form and connectivity for my app?