Search results

I'm importing an Excel File into Access from a vendor and they use the name MONTH and YEAR in the Excel File. I will change them after or before I import the file going forward. Thanks for the advice.

@vbaInet Thank you for all your help. How will converting this to a function fix my problem? Regards, Rich

@Uncle Gizmo The iif statement is working by itself. When the expression is true it produces a number code that I am trying to use with a table. Example: Say I have this iif statement Light_Code:If([Field1]="Red","1",IIf([Field1]="Green","2","Caution")) My table looks like this ID, CODE...

Hi Everyone, I need some help with an error I'm receiving when I try to setup a relation between the results of a IIf statement and a table. The IIf statement produces result codes is here: DISCREPANCY CODE: IIf([STATUS]="I" And [CLAIM STATUS]="PAID CLAIM","1",IIf([STATUS]="I" And [CLAIM...

I think I figured it out. I used the Sql Code below and it worked. I also used this http://office.microsoft.com/en-us/access-help/update-data-by-using-a-query-HA010076527.aspx#BM5 to help me as well. UPDATE [Test tblGHIACCURACYFILE] LEFT JOIN dbo_depfile1 ON [Test tblGHIACCURACYFILE].MemberSSN...

I need some help with copying/updating data from a database table to another. Details: I have a MS Access table containing Dependent social security numbers but some of the dependents social security numbers are blank. I have a MS Sql Database that contains a table with most of the missing MS...

I just wanted to say thanks to everyone for helping me. -Rich

I used this code to calculate DOS age and it works as well. Age at DOS: DateDiff("yyyy",[TestDOB],[DOS])+Int(Format([DOS],"mmdd")<Format([TestDOB],"mmdd")) I see that your code works and is not as long as mine (Which I like) and it displays the age as "00" If my code is not correct or if I'm...

The Int function returns the integer portion of a number. (Rounding numbers). I used it in another query and thought it would work but it didn't. The code namliam provided proved that I didn't need to use Int or Format functions. I tend to make things harder then they need to be. LOL! Thanks...

Hello everyone, I need some help with an age query. Here is the situation: I have a date of service [DOS] and a date of birth [Birth Date] I'm trying to calculate the age at the last day of the date of service year not the current year. Example: [Birth Date] = 6/25/1993 [DOS] = 10/18/2013...

Your correct Paul, I corrected the code and it works, Awesome! Thanks Brian and Paul! -Rich

When I tried LDOY: DateSerial(Year([DOB]+23, 12, 31) I received a message saying "The Expression you entered has a function containing the wrong number of arguments." I reviewed the code and added a closed parenthesis after +23 and it ran without any error messages but it didn't produce the...

Yep, that works perfectly! Thank you so much!

To add 23 years to the DOB I used this "DateBecame23: DateAdd("yyyy",23,[DOB])" To Modify the date to Last day of Year (LDOY) I used this "LDOY: DateSerial(Year([DateBecame23]),12,31)" I don't know how to join these two functions into one function.

Good afternoon Everyone, Any help will be appreciated. I have a date of birth field (DOB) and want to be able to add 23 years to the DOB then I want to take the result and modify the date to the last day of the year. Example: DOB = 11/17/1969 Date Became 23 = 11/17/1992 Modify Date Became 23...

Thank you finished this part of the project. Couldn't have done it without your help! Thank you!

FYI Namliam, I finished my other project and starting to work on this one again.

I'm still working on this issue namliaM. I was pulled off of it to work on another project for now. I will let you know when I'm working on this issue again.

The code provided by Plog worked perfectly. Thank you Plog!

Thank you for the quick response Namliam, It is amazing how you were able to create the resulting query close to what I needed but it is not working the way I wished it would. That’s my fault I was not clear on what I needed, sorry about that. The client should appear on the qryTableAResults...