Query Help!

  • Thread starter Thread starter Robert Morris
  • Start date Start date
R

Robert Morris

I'm in the process of developing a query that would only
show me people who are late with their payments and would
also add a late fee to the outstanding balance?

So far I know what I want to ask is who has an
outstanding balance of > $x amount on x day then add $x
amount to outstanding balance as a late fee.

Please Help!

Robert
 
Here is what I did to recreate your question.
I created a table called tblCustomerBalance with the
following fields:
Name
Date
Balance

I created an update query which determines the customers
overdue and have a balance. I assumed my due date was
July 1st and the late fee was $50.

UPDATE tblCustomerBalance SET tblCustomerBalance.Balance =
[Balance]+50
WHERE (((tblCustomerBalance.Date)>#7/1/2003#) AND
((tblCustomerBalance.Balance)>0));

Thanks
Terri
 
Thanks Terri,

I'll give this a try and will let you know if I'm
successful.

Robert
-----Original Message-----
Here is what I did to recreate your question.
I created a table called tblCustomerBalance with the
following fields:
Name
Date
Balance

I created an update query which determines the customers
overdue and have a balance. I assumed my due date was
July 1st and the late fee was $50.

UPDATE tblCustomerBalance SET tblCustomerBalance.Balance =
[Balance]+50
WHERE (((tblCustomerBalance.Date)>#7/1/2003#) AND
((tblCustomerBalance.Balance)>0));

Thanks
Terri
-----Original Message-----
I'm in the process of developing a query that would only
show me people who are late with their payments and would
also add a late fee to the outstanding balance?

So far I know what I want to ask is who has an
outstanding balance of > $x amount on x day then add $x
amount to outstanding balance as a late fee.

Please Help!

Robert

.
Click to expand...
.
Click to expand...
 
Back
Top