Search results

I am writing a Pension Program for my company. I am extracting the data from our HR system (.dbf) the has the Employee info in one table and the spouse info in an other table. In order to populate or grab the employee we want to run a calculation for I have a pop up box that asks for the SSN...

Doug, Thanks so much. I changed the regional settings and it worked. I guess I just assumed that having set the formatting in Access would make the formula work. Once again, thanks for all your help. Patrice

Thanks for the quick answer. I did go into Modules|New then did the Tools|Reference. I did see a difference in the setup and went back to my system and changed the settings but I am still having the same problem. I did discover that if the DOB month was 10, 11 or 12 the formula in the form...

I have a form with the following expression: NRD: IIf(Left(DateAdd("yyyy",65,[E DOB]),2)="12" And Mid(DateAdd("yyyy",65,[E DOB]),4,2)>16," 01/01/" & Right(DateAdd("yyyy",65,[E DOB]),4)+1,IIf(Mid(DateAdd("yyyy",65,[E DOB]),4,2)<=16,Left(DateAdd("yyyy",65,[E DOB]),2) & "/01/" &...

Thanks for the quick answer. Now I have another question...how will this handle Dec/Jan. If the employee was born 12/23/1957 then his NRD will be 01/01/2023. Will this fuction handle something like this. Also, I am very new to programming in Access, where do I put this function. Thanks for...

I hope someone can help me. I need to calculate a Normal Retirement Date. That is the date that you are 65. Also, when calculating this date if you are born <=16 of the month then the date needs to be the first of that month (ex. dob=7/12/57 the NRD would be 7/1/2022) and if you are born...