Query Help!

[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

 

[Terri Pecora]

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

 

[Robert Morris]

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

.

.