Search results

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..

Ofcourse i did my own research also sir..

Thanks pat, i will see if i can implement your solution.. I am at beginners level, and have that difficulty in using code.. That is why i am always looking a demo every where..

Thanks Thanks The-Doc-Man, Atleast you pickup my level in terms of solving db problems, and you step down at beginners level in giving solution.. Beginners like me is always looking a demo on how to do things correctly.. Guru's / Expert's here should have that in mind..

Hi CJ_London, Yes i requested the other post to be ignored or deleted, as said it is accidentally posted and it is not completed yet, for some reason i cannot just edit it, so i created again, i am typing on my cellphone..

Hello all, Just today when i opend and browse one of my table, i found out that some rows are blank.. Can someone pls help me, what causes this blank rows, and how to trap and avoid this to happen. All my entry form are bound to a table. Thank you..