Query with date

[glamster7]

Hi,

Am struggling a little bit with this today.Some help would be gratefully Welcome


I have a table Salonmanagerdet ail which has the following fields

Mananger_Id Pk Autonumber
Stylist_Id Number
SM_Dates Date/time
SM_Phrase Text

This information is entered via a form Salonmanagerdet ail & allows the salon receptionist to enter details of when a stylist is Salon Manager. what I'm wanting to do is either create a query or write in some code which looks at each SM_Dates & checks to see if it is equal to todays date -if it is it puts the phrase "SM" in the SM_Phrase field , if it isn't it leaves the field blank

Thanks In adavnce

[Rabbit]

What about using the iif() function?