Impress Account Issues

[Moore71]

Hi,
I want to develop an expenses platform. My problem is how do I create it such that when an impress amount has been approved by the admin/manager, all daily expenses cannot exceed that approve sum for the weekly/monthly or quaterly. And moreso, until that approved sum is exhausted, new impress cannot be approved and the daily/weekly/monthly or quaterly expense cannot exceed the approved impress.
Thank you for your quick response

 

[Ranman256]

You'd need at tLimit table to set the limit of (every Person?)
And a TimeCode (monthly M,daily,D, weekly W)

PersonID, Limit, TimeCode
984, $500, M
324, $100, W

When processing a persons totals, you'd have to
Make a weekly query,and a monthly query,etc.
Then a query to show,
PersonID, TimeRange, limit, AmtSpent, AmtAllow, AmtDenied

 

[Moore71]

Thank you for your response.
So how do I prevent anyone who has exhausted his / her limit for making further expenses until next week, next month or next quater?

Thanks, once again.