Re: criteria and dates

Assuming that [DateField] is in fact of type DateTime, then you need to
place the literal date between #...# as in:

IIf (([DateField] >= #01/01/2002#, [do calculation], " ")

Good Luck!
--

Chaim


"kryszystof via AccessMonster.com" <forum@xxxxxxxxxxxxxxxxx> wrote in
message news:545130854466E@xxxxxxxxxxxxxxxxxxxx
> Nevermind, I still need help!
>
> more ways than one! lol
>
> kryszystof wrote:
> >wow!, I fixed my problem myself!
> >
> >thanks to anyone who might have wrote back!
> >
> >(i removed quotes~ works like charm)
> >>Sorry,
> >>
> >[quoted text clipped - 15 lines]
> >>
> >>>Hello to all,
>
>
> --
> Message posted via AccessMonster.com
> http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200509/1


.

Relevant Pages