Really need some help here :(<3

[Hannah287]

I dont have the date they were paid, i am unaware of these..

[jzwp11]

As long as you have the field in the table, the expression will yield one of the two messages since the date field will be null. You will have to populate the bonus paid date eventually.

[Hannah287]

I have entered this and got 'The Expression you entered contains invalid syntax.

'You may have entered an operator, such as the +operator, in an expression without a corresponding operand.

[jzwp11]

You will need to check the spelling of the field/control names as well as the placement of the parentheses. If you want us to take a look at it, you can zip and post your database. Please make sure to alter or remove any sensitive information.

[Hannah287]

=IIf(IsNull( [Employee]![Loyalty Bonus Paid Date] )IIf(DateAdd("d",500 ,[Employment_Date])>Date(),"Bonus is not due to be paid","Bonus is now due to be paid"),Null) That all looks correct but im still getting the error?

[jzwp11]

Missing a comma & and a closing parenthesis (shown in red)

=IIf(IsNull([Employee]![Loyalty Bonus Paid Date]),IIf(DateAdd("d",500 ,[Employment_Date])>Date()),"Bonus is not due to be paid","Bonus is now due to be paid"),Null)

[Hannah287]

NOW i have the wrong number of arguments, god i hate access!

[Hannah287]

Ok i should have it working but whenever i turn back to the report view it asks me for a parameter for Employee!

[jzwp11]

Remove [Employee]! from the expression (i.e. just use the field name)

[Hannah287]

new box has come up saying 'Loyalty Bonus Paid Date' with an input box

[Hannah287]

It only works if i leave it blank and click ok, then all the boxs say the bonus is due (which it is). But is there any way to stop that box from appearing ?

[jzwp11]

It is looking for the field. Did you add it to the report's record source?

[Hannah287]

Absolute Legend!

[Hannah287]

One last quick thing, after i input a date paid will the reminder disappear ?

[jzwp11]

Once a date paid is entered for an employee, there should be no message shown in the textbox. You can test it to see if it meets your needs.