Re: Report based on calculations of 2 records

Hi Kelvin,

Do you have standard PayFrom and PayTo dates? Or do they vary depending on the customer? How are these dates defined?

Warm Regards,
Crystal
Microsoft Access MVP 2006

remote programming and training
strive4peace2006 at yahoo.com
*
Have an awesome day ;)


Kelvin Leong wrote:
I have 2 tables, one is the CustomerInfo and the other their Transactions. I have a form which shows individual CustomerInfo from the CustomerInfo table, and a subForm which shows their payment history from the Transactions table in a data*** format.

From the Transactions table, there are 2 particular columns that is important, namely PayFrom (date) and PayTo (date). Lets say that this customer has made 10 payments, records 1 to 10. I want to know whether (PayFrom (date) from [record 2]) equals to (PayFrom (date) of [Record 1]) + 1. SImilarly, I want to know whether (PayFrom (date) from [record 3]) equals to (PayFrom (date) of [Record 2]) +1, so on and so forth.

How am I able to generate a report to show that for a particular customers' payment history is entered correctly, that is the PayFrom (Date) of the latter record is 1 day after the PayTO (date) of the previous record?
.