Advanced Filter Issue

For some reason I can not get the criteria right for this...any help
mound be appreciated.

Field1 Field1 Field2
>=12/31/05 <=3/31/06 >=3/31/06

I am trying to filter all records in the between the two dates in
field1 AND the records must also have a date greater than field2.

It works perfect when I the criteria is on the 2 Field1 criteria but it
does nothing when I add Field2 to the criteria.

Ideas?

Do you have 2 date columns so that you want to filter the dates in one
column that is between Jan 1 AND Mar 31 AND the dates in a second column
that is greater than Mar 31. Then your criteria works.
It obviously won't work for one column of dates but for 2 yes it does work

--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com



<michaelburkett@gmail.com> wrote in message
news:1146086411.250340.236460@g10g2000cwb.googlegroups.com...
> For some reason I can not get the criteria right for this...any help
> mound be appreciated.
>
> Field1 Field1 Field2
>>=12/31/05 <=3/31/06 >=3/31/06
>
> I am trying to filter all records in the between the two dates in
> field1 AND the records must also have a date greater than field2.
>
> It works perfect when I the criteria is on the 2 Field1 criteria but it
> does nothing when I add Field2 to the criteria.
>
> Ideas?
>