Working !
It is a little rough and i am still testing but the results are there. I could not use the "Between" statement in the query but "Is smaller than" and "Is larger than". but you absolutely pointed me in the right direction.
Thank you very much!
Maverex
Last Activity: Sep 18 '10, 09:04 AM
Joined: Sep 17 '10
Location: Oldenzaal, The Netherlands
-
I do not have the time to test this right now. I looks good but in the first test return too much records. I will test it very soon and get back to you. Thanks for the help so far.Leave a comment:
-
In the query there are real dates generated, so one of the criteria is that the dates must then also be the same.Leave a comment:
-
Hi ChipR,
That is correct. And on top of that, the two queries are indentical. In fact it is one query and i want to check in that query if a "start time" falls between "All the start times" and "All the and times" .
It is a query with recurring events and i want to check if an employees planning time is clashing. He can not be in two places at the same time :-)Leave a comment:
-
Designing a query to find matching records in 2 other queries.
I want to design a query that checks 2 other queries for overlapping planning times. I generate recurring events in a query. It generates dates and beginning times and ending times. There is also an itemID int the records. I want to chech if that item beginning time clashes with time slots in the other records in the same query. I was thinking of putting the querie twice in one other. But how do i compare all the records to each other ?
...
No activity results to display
Leave a comment: