Query to show actual payment vs projected payment

[Tokolosche]

Hello,

I have a database where it records a customers information of a set payment over a set number of weeks. E.g. Payment of $50 per week, over 52 weeks.

So I want the query to show what the total payments should be at week 20, and what the actual total payments are. E.g. At 20 weeks payments made should be $2,000, but if the customer has only paid $1,500, I could see the difference.

Any examples anyone could give me would be very appreciated!

Thanks
Drew

 

[lespaul]

depends on your table structure. How about showing us some table names and the fields and sample data and expected resulted?



Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for database developers:
The Fundamentals of Relational Database Design
Understanding SQL Joins

 

[Tokolosche]

Hi Leslie,

Thanks for your response.

I am not sure what info you are after for the table structure? The data this is stored in is the same table as the customer information.

Field names:

DAP$ (currency) - this is the amount that the customer needs to pay per week.

DAPWeeks (number) - This is the number of weeks the customer needs to pay over

AmountPaid (currency) - This is a manually upadted field that reflects what the customer has actually paid at any given time.

I don't actually have any sample data as of yet as this is brand new. The example I gave above is indicative of what will be entered in though. If you need be to create some examples I can.

 

[Golom]

Is it just

Select DAP, DAPWeeks, AmountPaid
     , (DAP * DAPWeeks) As [Computed Total Payment]
     , (AmountPaid - (DAP * DAPWeeks)) As [Difference]

From ...

?