Re: criteria and dates

From: "kryszystof via AccessMonster.com" <forum@xxxxxxxxxxxxxxxxx>
Date: Tue, 13 Sep 2005 19:20:45 GMT

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

kryszystof wrote:
>Hello to all,

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

Follow-Ups:
- Re: criteria and dates
  - From: Marshall Barton
- Re: criteria and dates
  - From: kryszystof via AccessMonster.com

References:
- criteria and dates
  - From: kryszystof via AccessMonster.com

Prev by Date: criteria and dates
Next by Date: Re: criteria and dates
Previous by thread: criteria and dates
Next by thread: Re: criteria and dates
Index(es):
- Date
- Thread

Relevant Pages

fill combobox from selection from another
... how to with VBA and/or query? ... Prev by Date: ...
(microsoft.public.access.formscoding)
Re: ? re "Trusted Root Certification Authorities"
... TIA, ... DaveB ... Prev by Date: ...
(microsoft.public.windowsxp.newusers)
database link
... query. ... TIA ... Niraj ... Prev by Date: ...
(comp.databases.oracle.misc)
Filter A Query?
... How do I filter a query based on a date range contained in 2 boxes on ... Prev by Date: ...
(microsoft.public.access.formscoding)
Query Filter
... How do I filter a query based on a date range contained in 2 boxes on ... Prev by Date: ...
(microsoft.public.access.forms)