Search results

I take it that this is either not possible or extremely difficult to implement...

Hi, I need to compare records in the same table. I know that this is typically accomplished by joining the table with itself. However, this is not entirely suitable for my needs. I need to compare the first record to every other record - excluding itself - and then compare the second record to...

The feedback is much appreciated. I'm not sure DCount would work in this case however. I'm essentially counting pairs of flights that are in danger of collision. eg: Flight A and Flight B are at "almost" the same place at the same time. "Almost" is determined if Flight A is at the location of...

That sounds like a great idea! Thanks for your help!

Hi! To determine whether a record is in range of another or not is based on several fields ie: They have to be at the same location within a certain window of time and various other factors. I've already tried the Query/Subquery route and it seems to lead to a dead-end. I'd prefer to do it...

Hello, I'm trying to write a relatively simple function. What I want it to do is count pairs of records within "range" of one another - to determine whether a record is in range or not is trivial. So I want to compare the first record to every other record in the table, second record to every...

Hello, I've been wrestling with this problem for a while now and any assistance would be greatly appreciated. I have a single table containing flight data. Each record represents a single flight. What I'm attempting to do is count of pairs of flights that come within a certain range of each...