hi all,
basically the senario is this , i'm re-writing a segment of a rent management database i use to handle student rent and bills in two houses. even though i'm on version 4 i've never been able to write a section to handle bills that truly works.
Bills come in at different times and have a start and finish date,
during that time there could be any number of people coming and going.
My idea is to create a table that writes a line for each day of the bill period, with this table created i can then work out how many people are present in the house (under contract that is) on each day and split the bill amount into a fair amount for each day. Then stage three would be for every day that a student is under contract for a house add the amount of the bill for that day inserting that into a second temporary table, calculate the final amount each student has to pay , delete the temporary table and vola , bobs your uncle
or in my case my dad ...
sounds simple but unfortunately i've fallen at the first hurdle, my SQL isn't bad but my VBA is more than basic so have no idea how to create a temporary table and insert a row for every date between the start and end date .....
anyone got any time to help with this one would be much appreciated !
basically the senario is this , i'm re-writing a segment of a rent management database i use to handle student rent and bills in two houses. even though i'm on version 4 i've never been able to write a section to handle bills that truly works.
Bills come in at different times and have a start and finish date,
during that time there could be any number of people coming and going.
My idea is to create a table that writes a line for each day of the bill period, with this table created i can then work out how many people are present in the house (under contract that is) on each day and split the bill amount into a fair amount for each day. Then stage three would be for every day that a student is under contract for a house add the amount of the bill for that day inserting that into a second temporary table, calculate the final amount each student has to pay , delete the temporary table and vola , bobs your uncle
or in my case my dad ...
sounds simple but unfortunately i've fallen at the first hurdle, my SQL isn't bad but my VBA is more than basic so have no idea how to create a temporary table and insert a row for every date between the start and end date .....
anyone got any time to help with this one would be much appreciated !
