Append and also skip fields with certain text? (1 Viewer)

[kb44]

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.

 

[isladogs]

In the field concerned, add the filter criteria <>'No changes'

 

[kb44]

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

 

[kb44]

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 Null,[tbl_Select Current Month].[Country],[1-d Staffing_Display_Changed_Fields_NO_OPEN].[Country])

I hope this helps someone out.