Thanks, by the way count again LOL first 5 inserts are for the month of 09.......:D

I think I got what I was looking for with a little more messing around with what I already had. Seems to work like I wanted it to. This is...

Here is some data that I used to insert into a table RentalHistory:

INSERT INTO RentalHistory VALUES (462, '09-22-2008', '09-24-2008', 317, 111, NULL );

INSERT INTO RentalHistory VALUES (463, '09-22-2008', '09-25-2008', 329,...