If then statement for time (1 Viewer)

[cktcPeterson]

I have a field with the current time

I want to have another field that says either good morning or good afternoon based on the time.
[txtTimeAMPM] is a unbound field set to short time.

=IFF([txtTimeAMPM]<=TimeValue("12:00"),"Good morning","Good afternoon")

I am getting a #Name

Please help me.

Thanks
Cheyenne

 

[theDBguy]

Maybe you meant to use IIF, instead of IFF?