Billing date calculation problem

[Guest]

Hello,

I am creating a billing database in (Access 2003) wherein a customer will be
billed yearly for services depending on the start of the service.

If the service activation date is 5/14/2005, I want to create a calculation
that bills the customer the yearly rate on 5/2006, 5/2007, etc.

I want to run statements monthly.

I am using the DateAdd onto the year but this still poses problems: Right
now I am saying if [activation_month] = [current_month] then bill the yearly
rate. In this case, it bills every time I open the database during that
month.

Is there another way to do this?

If anyone has any ideas on how to set this up I would greatly appreciate
your insight.

Thanks

 

[David Lloyd]

One approach would be to add a field to track the last billing date. You
can then add comparison of the year of the last billing date to the current
year. You will need to add the logic for updating the last billing date
field of course.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.


Hello,

I am creating a billing database in (Access 2003) wherein a customer will be
billed yearly for services depending on the start of the service.

If the service activation date is 5/14/2005, I want to create a calculation
that bills the customer the yearly rate on 5/2006, 5/2007, etc.

I want to run statements monthly.

I am using the DateAdd onto the year but this still poses problems: Right
now I am saying if [activation_month] = [current_month] then bill the yearly
rate. In this case, it bills every time I open the database during that
month.

Is there another way to do this?

If anyone has any ideas on how to set this up I would greatly appreciate
your insight.

Thanks