From: menard on
That worked - thank you for quick and accurate recommendation.


"John W. Vinson" wrote:

> On Sun, 4 Apr 2010 16:19:01 -0700, menard <menard(a)discussions.microsoft.com>
> wrote:
>
> >I am trying to use date information from an access database. I am not an
> >Access expert by any means. All I would like to do is change a date entry
> >from "7/27/2009 10:37:59 AM" to just "7/27/2009" (as I do not care about the
> >specific time), perhaps by adding another column to a table, or through some
> >other mechanism. I am not just looking to reformat for display - I am
> >looking to change the actual data from a date and time representation to a
> >date only so that the data queries I am making are easier to manage. Any
> >help would be appreciated.
> >
> >Thanks,
>
> To permanently and irrevokably remove the time portion from all records in
> your table, run an Update query updating the field to
>
> =DateValue([fieldname])
>
> using your actual fieldname.
>
> If you need to keep the time portion for future reference, you can (at some
> cost in query speed) use a calculated field
>
> JustTheDate: DateValue([fieldname])
>
> in your query and apply your criteria to it.
>
> It's admittedly a hassle, but you can use date only criteria in conjunction
> with a date/time field if you do it right. Perhaps you could post an example
> of a query that's giving you trouble if you'ld like some tips for doing so.
> --
>
> John W. Vinson [MVP]
> .
>