criteria form for Report

[fule12]

Hi to All ,

I make Query (Out Order) and for field Date put Craiteria :Between[Enter Beginning Date]AND [Enter ending date].So i got records with this craiteria.
But a nead two diferent craiteria for field "Data" in Query(report)
first one : from - to date
Second : <=Date()

any idea??
Thanks Fule

 

[jimmythegeek]

Isn't this counter-productive? If you enter between 1/1/2001 and 6/30/2001, it doesn't really matter what your other value is, as the 6/30/2001 is acting as your maximum and the 1/1/2001 is acting as your minimum date.

Anyway, if you need to do it, it would look like this:

(Between [Enter Start Date] And [Enter End Date]) And (<=[Enter Maximum Date]) Jim Lunde
compugeeks@hotmail.com
We all agree your theory is crazy, but is it crazy enough?