Select Date in Access query

[Peter]

Hi all, i have a small problem. In my query i have set the criteria for a my
cases to "open or review"...in the date due column i have prompted for a
date...but how do i make the criteria also selct all cases that are open or
review prior to the selcted date due?

 

[Marshall Barton]

Hi all, i have a small problem. In my query i have set the criteria for a my
cases to "open or review"...in the date due column i have prompted for a
date...but how do i make the criteria also selct all cases that are open or
review prior to the selcted date due?

How do you tell if a record is open or review?

 

[KC-Mass]

Hi Peter,

Set the Criteria for the prompting Date Field to "<[Date Due]" (omit the
quotation marks)

Regards

Kevin

 

[Peter]

Hi KC-Mass..thanks for your reply it solved part of my minor problem...how do
i also include the criteria date...now i get all dates due prior to the
criteria date..not including the criteria date...once gai thanks..and happy
holidays.

Hi Peter,

Set the Criteria for the prompting Date Field to "<[Date Due]" (omit the
quotation marks)

Regards

Kevin

Hi all, i have a small problem. In my query i have set the criteria for a
my
cases to "open or review"...in the date due column i have prompted for a
date...but how do i make the criteria also selct all cases that are open
or
review prior to the selcted date due?

 

[Peter]

HI again...i found it <=....sorry to take your time. Simple solutions for a
simple issue.. Once again, thanks for directing me in to the correct
path..ciao!

Hi KC-Mass..thanks for your reply it solved part of my minor problem...how do
i also include the criteria date...now i get all dates due prior to the
criteria date..not including the criteria date...once gai thanks..and happy
holidays.

Hi Peter,

Set the Criteria for the prompting Date Field to "<[Date Due]" (omit the
quotation marks)

Regards

Kevin

Hi all, i have a small problem. In my query i have set the criteria for a
my
cases to "open or review"...in the date due column i have prompted for a
date...but how do i make the criteria also selct all cases that are open
or
review prior to the selcted date due?