I need to create a database that tracks the usage of a resource on a monthly basis. I have the tables built that will track the contracts, clients, etc. In the contracts table I have a start date and an end date that are tied back to an inventory item.

My question is how can I shows these on a datasheet like this, so that is shows the inventory items and who has what that month.

Item Jan Feb Mar ....
INV#1 Joe Joe Barb

I set up the tables for the data I need to store, maybe the start/end date won't work.

Thanks,
turbow

Actually its set up OK. You should have an end date so that you know when that item will be available for the next person who wants to use it.

Thanks, then how do I take a start/end date field and display it on a datasheet that shows who is using the resource each month?