Recent content by moi

Dear All, Can somebody help me how to show my criteria on to my report header.. I based my report on a query and fill the criteria (StartDate) and (EndDate) to "PDate" control from a form where i open my report.. I would like to display the value of the StartDate and EndDate to my report.. I...

Hello Gasman, It is not the way I wanted, but it is their way to count the start and end of the monthly payment of the buyer.. It is their calendar to schedule the payment of the buyer.. so yes a bit stupid but that is their way.

Hi pat, Sorry for late reply.. you got it right, that's how they schedule the start to end of the monthly payment of the land buyer.. if the buyer decided to go to a 36 month.. then it will start the monthly payment on 30-Jul-2024 (the day it signed the contract) and it will/should...

Thank you cj_london

Thank you gasman..

They are using number of months 24, 36..

Ye Yes that is what they wanted.. I need to follow what they are using..

Hello The-Doc-Man, What is their typical intervals are 2years (24mos), 3years (36mos).. They are using 24/36 mos.. No other intervals they are using..

As of now, what i have is the same i posted..

Hi, yes exactly..

Hi GaP42, Terms is value (24/36)..No it is not always end of the month.

Hi plog.. Many thanks for picking up my post.. Thats what they calculated for 3 years from 30-jul-2024, so i need to follow that calculation..

Hello all, I have this dateadd function, i wanted to add a year (2/3yrs) depending on the value of "terms" and "ctsreleased" field.. =DateAdd("m",[terms],[ctsreleased])-1 Like i have a date "30-Jul-2024", i want to give a me date "29-Jun-2027". Thank you.

Thank you, am trying to digest all your recommendations/suggestions..

Thank you for telling me that sir.. Atleast the next time i come to your page i will know how to write..