Late fees based on due date

[CoachBarker]

I am having trouble coming up with a query that will assess late fees based on a due date. Payment is due the 1st of every month, if after 10 days payment is not received then a 15.00 late fee is charged. CAn any one help me out, not really good with dates and it needs to be in a query so I can run the query in vb.net.



Thanks
CoachBarker

[NTC]

well first you make a query that results in the correct records of those that are late. Call this qFindLates. I will guess there are 2 key criteria: null in the payment field (put Is Null) and the paymentduedate field is over due (put <11/1/10)

what one does next depends - not sure if there is a late payment field or what....and also whether that value of $15 varies across time or could change in the future etc...if the FindLates isn't a huge quantity of records one could just manually enter in the value. if the FindLates is alot of records then you would make an UpdateQuery to enter in the value in mass. or maybe you want to make a Late Invoice and source it on this query... it all depends...

hope this helps a little.