I am trying to run a query that returns any records with todays date in the memo field. I am using the Now() function in the memo field after an update --> Me.Notes = Me.Notes & vbCrLf & Now() & " " & Space(3) & CurrentUser
It doesnt seem to recognize the date as just the date, but everything after it. Any ideas on how to query for the current date stamp in a memo field? Thank you in advance for your help.

Dino

The Now() function returns the current system date AND time

The Date() function returns only the current system date, which is what you want.

Would I be able to query off of the date() function in my form?

Thank you for your suggestion...however when I try to query that date in the form,and it still doesnt pick up the record. I can use a query with "*12/12/01*" and it will pick up all records...I dont want to have to change the date of the query everyday though. Any help you can provide is very much appreiciated.

Now I think I understand. You always want to select today's records while FILTERING a FORM, using a date extracted from a memo field.

Is that correct?

That is correct. Sorry my explanation was so convoluted.