Need Some directions please

[devinh]

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

[Stuart Taylor]

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.