HELP WITH QUERY - MONTHLY PAYMENT COUPONS

[mauricionava]

Hello, I work in a loan company and need to make payment coupons to our customers. I created a query with the AMTPAY, NEXTPAY, AMTLATE and LATEDATE. I ran the query with an especific account but I need to get all result from an especific range. For example, I need the start date to be 10/01/2005 and end date 10/01/2008 and the query to display all monthly or bi-weekly payments in that range. I will then put the query in a report. Please help.

Thanks.

 

[JoyInOK]

Are you asking how to specify a date range as the criteria in a query? The syntax is:

Between #10/1/05# and #12/15/05#

 

[mauricionava]

Hello,
It's not "specify", it's generate. Sorry.

My database has only one field of date which is the STARTDATE and I need to generate what would be the next payment of the customer either monthly or bi-weekly and in a 4-years range.

Thanks!

 

[PHV]

Have a look at the DateAdd function.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886