Filter Query

  • Thread starter Thread starter Matt
  • Start date Start date
M

Matt

I want to filter a Query by dates between today and all future dates. How
can I do this? The point is to be able to run a report on all dates
including today into the future for scheduling.
 
The Date() funtion returns the current date, so your criteria might look
something like;

.......WHERE [YourDateField] >= Date()
 
Awesome, thanks man, I appreciate it!
--
-Matt

"The only thing worse than an employee that just quits and leaves, is an
employee that quits and doesn''t leave."


Beetle said:
The Date() funtion returns the current date, so your criteria might look
something like;

......WHERE [YourDateField] >= Date()
--
_________

Sean Bailey


Matt said:
I want to filter a Query by dates between today and all future dates. How
can I do this? The point is to be able to run a report on all dates
including today into the future for scheduling.
--
-Matt

"The only thing worse than an employee that just quits and leaves, is an
employee that quits and doesn''t leave."
Click to expand...
Click to expand...
 
You're welcome.
--
_________

Sean Bailey


Matt said:
Awesome, thanks man, I appreciate it!
--
-Matt

"The only thing worse than an employee that just quits and leaves, is an
employee that quits and doesn''t leave."


Beetle said:
The Date() funtion returns the current date, so your criteria might look
something like;

......WHERE [YourDateField] >= Date()
--
_________

Sean Bailey


Matt said:
I want to filter a Query by dates between today and all future dates. How
can I do this? The point is to be able to run a report on all dates
including today into the future for scheduling.
--
-Matt

"The only thing worse than an employee that just quits and leaves, is an
employee that quits and doesn''t leave."
Click to expand...
Click to expand...
Click to expand...
 
I've been trying to write a question about schedulying and this is the only
window that I can get to pop up. my question is: I have a 24/7 business.
want to develope sch. that will post 1,2,3 shifts and will not post employee
after 40 hrs have been reached. is there such a program? Thanks
 
Back
Top