Remove time stamp

[am]

Hello,

In my query I have a field called Rec'd date it has a date and time stamp.
How can I show only the date but not the time in my query. Any help will be
appreciated. Thank you in advance.

 

[Tom Ellison]

Dear Alex:

See the DateValue() function for this purpose. Just use
DateValue(YourColumnName).

Tom Ellison