What is the best way to copy data from field to another in certain cases?

My table has the following fields:
RoleID
RoleCode
PrimaryRole
ReportCode
ReportRole

I tried creating this table-level validation.
ReportReport: IIf([RoleID]<>5 Or [RoleID]<>6 Or[RoleID]<>7 Or [RoleID]<>8,
[PrimaryRole],"")

The error message reads: The expression you entered contains invalid syntax. You may have entered an operand without an operator.

How do I get the PrimaryRole to copy to ReportRole except when RoleID = 5,6,7 or 8?