Design issue with Access 2000 - report records that leave and come bac

[SuperFreak]

Folks,

I am developing what I thought would be a simple database, but it is turning into a pain. Basically, the database is for keeping track of Community Service hours worked by offenders. I have a master table that contains their information as well as the day and the number of hours they were assigend. Then I have another table that shows the hours that they worked and when. I created queries and the info comes back fine. The problem is with the reports. I'd like to know how when an offender has zero hours that he\she could be dropped from the report. The kicker is, if they are re-assigned hours, they will have to come back on. I don't know SQL language at all, and I'm starting to think that this is probably required.

I hope that is enough info for you to understand my problem. Any help would be greatly appreciated. Thanks!

 

[grnzbra]

Just a thought off the top of my head, but if you used one table, let's call it Transactions (being assigned hours is one type of transaction while working some off would be anothe type.) Hours assigned or reassigned would be positive and hours worked off would be negative. Then you would be looking for a sum of zero hours.

 

[SuperFreak]

Eureka! I was so bogged down in the idea of keeping things seperate, I never thought of that angle. Thanks. Now the only question is, how do I filter the reports to ignore the records that result in a zero balance? Seems like you can't put a filter on a report...?