why?

[quantz]

iii...
i have one problem in date query...
i try to list the date between start date and end date....
i used this statement:
between [start Date] and [end date]
but i get only item on the start date and end date not the item between the date...
why this happen can anybody help me..
for your information my date field is name as myDate..
please

 

[e2cheng]

Hi Quantz,

I had a similar problem.

try this:

Is Not Null And Between [Forms]![name of form]![BeginningDate] And [Forms]![name of form]![EndingDate]

but make sure it's all on the same line.

Hope that helps

 

[neileg]

It works fine for me.

Have you got your date formats correct, e.g. Us or non-US format

 

[Rich]

Is the Between [StartDate] And [EndDate] on the criteria line of your Date Field?

 

[e2cheng]

yes.

you might also want to refer to the 'Sales by Year' form of the Northwind Database sampel database that may be on your computer.

 

[Gootz11]

this always works for me

>=[start date] and <=[End date]