Select Date in Access query

  • Thread starter Thread starter Peter
  • Start date Start date
P

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?
 
Peter said:
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?
Click to expand...


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

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

Regards

Kevin
 
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.

KC-Mass said:
Hi Peter,

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

Regards

Kevin

Peter said:
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?
Click to expand...
Click to expand...
 
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!

Peter said:
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.

KC-Mass said:
Hi Peter,

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

Regards

Kevin

Peter said:
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?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top