G
gg
Hi!
I'm writing out amounts by date for a contract with a starting
date=1/1/2005, ending date=12/31/2005, and term=12 months, total=$6k. These
fields reside in a detailed contract form within a main contract form.
1/1/2005 $500
2/1/2005 $500
3/1/2005 $500
..
..
12/1/2005 $500
I've saved these date fields and amounts in a Billing table and would like
to only save records into a Approved Billings table, up to the date that the
user enters (i.e. 3/1/2005). What would be the best way to calculate the 1)
billing amounts to date (< user entered date)=i.e. $1000, 2) current
amount=$500, and 3) remaining amount to be billed (>user entered date)=$4500.
Is it better to calculate on the fly in a query and then report or store all
of these values in a table and then query from that? Need your advice.
Thank you!
gg :-D
I'm writing out amounts by date for a contract with a starting
date=1/1/2005, ending date=12/31/2005, and term=12 months, total=$6k. These
fields reside in a detailed contract form within a main contract form.
1/1/2005 $500
2/1/2005 $500
3/1/2005 $500
..
..
12/1/2005 $500
I've saved these date fields and amounts in a Billing table and would like
to only save records into a Approved Billings table, up to the date that the
user enters (i.e. 3/1/2005). What would be the best way to calculate the 1)
billing amounts to date (< user entered date)=i.e. $1000, 2) current
amount=$500, and 3) remaining amount to be billed (>user entered date)=$4500.
Is it better to calculate on the fly in a query and then report or store all
of these values in a table and then query from that? Need your advice.
Thank you!
gg :-D