Search results for query: *

Dhookom, Thank you for the suggestions, I was able to import the records successfully. Regards, OCM

Duane, Once I accessed the Get External Data, I'll choose the 3rd option 'Link to the data source by creating a linked table' As you suggested, I'll not included the Col_ID field in my excel file, correct? TIA Regards, OCM

Hi Duane, thanks! I received the following error: TIA, Regards, OCMhttps://files.engineering.com/getfile.aspx?folder=0a18895b-8dbe-48a8-9336-b22eef332c86&file=Sample.xlsx

Greetings, We receive monthly payments that a former employee used to input in the access db manually. In doing so, the Col_ID field is auto generated (primary key). Currently, we receive the monthly payments in excel format and I’m exploring to import the payments into access in bulk. The...

SkipVought, Thanks a lot for your suggestion. I was able to apply your solution and it is working as intended. Regards, OCM

Hi, Given the attached sample file, I would like to insert a column next to Status_ID, Department_ID, and User_ID, and name these columns as Status, Department, and User and populate descriptions from the (Status, Department, and User). How can I accomplish this? TIA Regards...

combo Thank you for your feedback and for the PQ resource link, I appreciate it. I’ll try your suggestions when I get back to work. Regards, OCM

Combo, Thanks for the reply post and lead me to PQ. It looks very powerful and I've a lot to learn. The sample you show was the expected result I was looking for. 1. Structure table: To make my table a structure table, all I did was I highlighted the data Insert > Table 2. PQ: to start, I...

Okay, I'll give it a try and post back if I have additional questions. I would also like to try this in Power Query, but I am not familiar with Power Query. If you can point me to a Power Query community forum and/or resources will be great. TIA Regards, OCM

Hi, Thanks for your response Skip No, I do not. I put n/a to show a given record didn't appear in one of the three data sources (in this example, source #3). I tried the formula = [@[ID'#]])*( [Completed date] = [@[Completed date]] ))<>3,"*","")] and received an error: Can you tell me...

Hi, I receive three monthly reports which I expect to see the values for the 'completed date' field should be consistent/the same. However, every now and then for the same person, the 'completed date' is not consistent and I would like to filter out these records so I can reach out back to the...

mintjulep, Thank you for the resource link. I applied the solution you provided and the formula worked nicely. B - A (Only in B): =IF(NOT(IFNA(MATCH(B2,$A$2:$A$42,0),FALSE)),IF(B2,B2,""),"") Regards, OCM

Thank you everyone for your input. I modified my formula as below and it worked nicely. =IF(ISERROR(MOD(IF(ROW()=2,0,IF(C2=C1,T1,T1+1)),2)),"",MOD(IF(ROW()=2,0,IF(C2=C1,T1,T1+1)),2)) Regards, OCM

Greetings, I’m trying to compare two columns and list what is in one, but not in the other list (sample attached). My template has 25 rows, if nothing is entered in columns A & B, I would like my formula to return blank. TIA Regards...

Greetings, I used conditional formatting along with formulas in excel to color rows differently when a change in the name occurs in column C. 1. conditional formatting: format values where this formula is true =$T2=0 2. In my helper column T, I used the following formula...

Andy, Thank you for your input. That is exactly what I was trying to accomplish. Sorry for not providing samples with my original post. Regards, OCM

Andy, that is correct. Regards, OCM

Greetings, Given the following fields; DOS (date of service) CODE eg. 747.12, 767.24, 777.56 etc I am trying to find out (count) those CODES that start with 767 per DOS. I only want one line per DOS. TIA Regards, OCM

Okay, thanks. I'll try it and post back if I've any questions. Regards, OCM

Andy, thanks. Correct, their login name is the same as their windows login. Where in my code do I incorporate your suggestion (syntax)? TIA Regards, OCM