Search results

Hi all, I need to build an expression that shows a 1 if the fields have changed (not if they are not both null or have if they both an empty space in them). Meaning, if the fields are empty, I do not want the field to return a 1. I have the IIF statement, but can't figure out where to put the...

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

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.

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

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

Hi all, I have been tasked with evaluating whether Access might be the best solution to this issue. *Background: I am fairly new to Access and am a new employee here. Microsoft software is used here for the most part. Info: 800 employees in 30 different countries Sales Employee records...

I am a new user of this forum after finding many solutions here before as a lurker. At this time I work in the US. I am fairly new to Access. I thank you all in this community for all of the help you give people like me every single day. I appreciate it and hope to pay it forward.