If this is a portal (Attendance) on the Employee Table (record). I would change some things to see if this helps. Change the calc to a summary field-- =Total of //whatever field you need a total on.
Do this on a copy of your DB
You can either filter the portal, or filter the relationship. Assuming the Date Range fields (start and end) are global fields:
Filter the portal
edit: forgot to mention you could do this with Execute SQL, although someone else will have to chime in for a solution
Filter the relationship:
I just didn't have the relationships in the actual table set up like that, they were all = instead of less than or equal and so forth. the portal was good. Thank you so much! 2 days into FileMaker and I'm diggin it