This is supposed to catch courses that have a start date prior to March but an end date in March.
Before I was simply sorting by >=#3/1/2017# and <=#3/31/2017#. But a course that starts prior to 3/1/2017 yet ends mid march should be included.
Thank you but This OR statement times out Access. The logic is most likely correct, but something else is up. I could change the time out value? Its been going for a few minutes though. :banghead:
Thanks for your reply. I tried to simplify the query by removing the form specific code and just put in the dates I'm trying to search. I did it in design view and the SQL comes out like this:
SELECT DISTINCT CLASSROSTERVIEW.STARTDATETIME, CLASSROSTERVIEW.ENDDATETIME...
Hi, thanks again for your reply. I appreciate it.
So I changed the code to:
WHERE (((DateValue([CLASSROSTERVIEW.STARTDATETIME]))>=[Forms]![FRM_EMAIL_TRAINEES_BY_DATE]![txtBeginOrderDate] And (DateValue([CLASSROSTERVIEW.STARTDATETIME]))<=[Forms]![FRM_EMAIL_TRAINEES_BY_DATE]![txEndOrderDate])...
If I enter in >= and <= I get any courses with start and end dates withing that range. But if a course starts before the startdate and ends midway within the range, it doesn't list the course. I want it do do that though. Not sure how to fix the query to do that.
Hello,
Yes it is there in the SQL query. Another person here suggested changing the query to find dates between the start and end date. In my SQL, it is set to do just that.
I'm trying to write a custom report for a program called Training Manager to be used in a mail merge. I'm almost...
Thanks for the suggestion. My query is a little more complicated because I had to remove HH:MM::SS from the date derived from a linked table ODBCed into a DB I can't alter.
How would I follow your suggestion with this SQL:
SELECT DISTINCT DateValue([CLASSROSTERVIEW.STARTDATETIME]) AS...
Hello,
Thanks ahead of time for any advice.
I have a query that pulls the startdate and enddate criteria from a form. In the criteria field I built the following expression: [Forms]![FRM_EMAIL_TRAINEES_BY_DATE]![txtBeginOrderDate]
The same is true of the enddate only the form field is...