Search results

  1. K

    Update query that does not create extra lines with changes?

    Hi all, I need to create an UPDATE query that updates tableB (destination) with the data from tableA (source) and that does not create an extra line for each change in the table. Here is the break down: two tables with matching id's tableA (source) has 6 columns and about 700 lines tableB...
  2. K

    Append and also skip fields with certain text?

    So, I found a better way. I inserted an IIF statement that if the field said "No Changes" it would be replaced with the original field: Country: IIf([1-d Staffing_Display_Changed_Fields_NO_OPEN].[Country]="No Changes" Or [1-d Staffing_Display_Changed_Fields_NO_OPEN].[Country] Is...
  3. K

    Append and also skip fields with certain text?

    Thanks. Ill try it tomorrow and get back to you.
  4. K

    Append and also skip fields with certain text?

    Hi all, I would like to use Append but also skip the phrase: "No Changes". So as not to append this phrase into the table receiving the changes. Is this possible? I looked around but have not found a solution. Thanks.
  5. K

    IIF Conditional formatting (Bold), and how to combine rows?

    Guys, So, no Bold. I actually didnt need it after all. Also, as far as the data that was not combined, it was because of some typos from the table name references. So it all works now. Thanks!
  6. K

    IIF Conditional formatting (Bold), and how to combine rows?

    Thanks but not what I was trying to achieve. I won't have repeating info from each row.
  7. K

    IIF Conditional formatting (Bold), and how to combine rows?

    Here is the current and expected output. I had to redact info because some of it is sensitive.
  8. K

    IIF Conditional formatting (Bold), and how to combine rows?

    Hi all, I have a query that runs fine but needs tweaking. It displays differences between an old file and a new file. I haven't been able to figure out how to do two things. Here is one entry: BU_Changed: IIf([Staffing_Differences_New_vs_Old].[Changed_BU_Y_N]=1,[Monthly_Staffing_No...
  9. K

    Update query to remove leading and trailing spaces from all columns throughout table

    Yeah. Come to think about it, Im sure they're not designing them. But something went very wrong somewhere. Ill have to see what is really going on in the background.
  10. K

    Update query to remove leading and trailing spaces from all columns throughout table

    Thanks. Ill keep this format in mind.. in case I get the opportunity to fix it. You never know!
  11. K

    Update query to remove leading and trailing spaces from all columns throughout table

    That's some hard core name parsing right there! Thanks. I wish I was the designer! This comes from HR. Hard to believe that a large corporation would allow this.
  12. K

    Update query to remove leading and trailing spaces from all columns throughout table

    That sounds about right! :D
  13. K

    Update query to remove leading and trailing spaces from all columns throughout table

    The names go as far as first, middle, last, lastlast-hyphenated names. It's crazy. They even have some nick names in parenthesis to the right of the full name. I am guessing that is what the person wants to be called.
  14. K

    Update query to remove leading and trailing spaces from all columns throughout table

    I completely missed that earlier. Thanks for pointing it out. Also ty for the warning about matching the names!
  15. K

    Update query to remove leading and trailing spaces from all columns throughout table

    I apologize. You told me how to solve this and I totally missed it!
  16. K

    Update query to remove leading and trailing spaces from all columns throughout table

    Thanks. I agree that one field per name is how this should have been done from the start and that it should be changed. I was looking for a way to do the whole list in one shot in an update query but I guess that is not an option. To separate them and then join them back together is a great...
  17. K

    Update query to remove leading and trailing spaces from all columns throughout table

    They are together in one field with a space in between the first and last name.
  18. K

    Is Access the best way to go about this project?

    Thanks for the advice. I will keep trying.:banghead:
  19. K

    Update query to remove leading and trailing spaces from all columns throughout table

    Lol. All I was trying to say is that they are unique and that trimming spaces from 800 plus unique names (sorry, I should have mentioned that there were so many) by typing each name in a query would be a real pain.
  20. K

    Update query to remove leading and trailing spaces from all columns throughout table

    Hi all, I have the need to trim leading and trailing spaces from multiple columns populated by individual's names. Each field is unique. From what I understand, Trim() will only work with an individual string (a unique name like "John Hancock", but will not work with "Bob Hancock" unless you...
Back
Top Bottom