September 15, 200619 yr I'm needing a way to see if I've gone over the limit on devloper. I've got these fileds right now. ================================================ gplate_maxsqft (Gobal filed, this # is the # that tells me when we need to change the devloper) PlateCount.tb (table =============== Plate_Date (When it was plated) Plate_count_sq (Total sq used) Logs.tb (table) =============== History_Date (Date) History_Devloperchange (Yes or No option) ================================================ So what I need is a way to get the Total sq used since the last time the History_Devloperchange says yes. I think once I've got that # I can then use it to check it to the gplate_maxsqft and see if I'm in range. I would like to give a % left or over but that's for later issue. Thanks Devin
September 16, 200619 yr This is too confusing to understand ... can you not post a file with an example and say what you wish to achieve in relation to that file.
Create an account or sign in to comment