Re: criteria and dates

Tech-Archive recommends: Fix windows errors by optimizing your registry

wow!, I fixed my problem myself!

thanks to anyone who might have wrote back!

(i removed quotes~ works like charm)
kryszystof wrote:
>Sorry,
>
>i have a query, and i want to create an expression that depends on a date
>field.
>
>i have
>
>Field1 | Field2
>Date Expr
>
>field 2is such: adj1: iif([DateField] >= "01/01/2002",[do calculation], " ")
>
>i think it has to do with the date format that i am searching by, or possibly
>syntax?
>
>TIA,
>~K
>
>>Hello to all,


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-queries/200509/1
.