Search results

I am so sorry if I made a mess here. In fact what I am really looking is more than that. I am looking for any record which is between the start and finish times with any other records. Not to only adjacent records but each record to be comparable to all other ones. I also have date field and...

I have added more records into a sample table and produces the wrong results. It runs OK with 4 records which you have created, but when i added 2 more records with no time overlaps to the table and run the query, it shows those records as well, though it should not. I will be greatful if...

JET which is the database engine that access uses is not smart enough at times. These types of queries do not show in design view. Therefore ,you have to handle all your edits in SQL View. I don't understand you last question.? Can you please explain again. dallr Thanks for your reply, its...

I have not tested on my small table, but I have downloaded your file and it works. (One thing though - when I click to design view, it would not allow to switch). The last time I tried, it went running, but froze again - i have waited for more than 10 minutes, so never had a chance to see the...

Thank you Dallr for your reply. I have used your query, but for some reason when I am trying to run - it hungs and never produces any result. Is there anything I am doing wrong?

Hi Dallr, this one although is part of my query, it is achieving to get different results. I thought will be easier to break down the problem and put them together by myself or leave them as separate queries. Sorry for a confusion

Thank you for your code - it works fine. The only thing is I didn't make myself clear. When it generates the date more than 1 it should generate more than on field1 too. I think this is was your first question asked. I have tried all the possibilities but no luck yet. If you could help...

Hi, I am trying to filter those records whith overlap times only. For example: field1 TimeStart TimeFinish rec1 13:00 15:00 rec2 14:00 14:30 rec3 15:00 16:00 rec4 14:30 15:00 This should output rec1, rec2 and rec4. But not...

I have managed to get the results on date with more than 6 occurences for the particular date, for example. But because I have used Group By, Having and Count I can't show all the columns. But if I do, then I have to use them in Group by, which generates different results. I have tried...

In fact the error message I am getting is this: Subquery returned more than 1 value. This is not possible when subquery followes with =, !=, <... thanks

Sorry for a delay Khawar and thank you for your reply. I have tried to run similar code given above, but produces some error messages. Only when I use Group By and Having on the same query layer, I am getting only one instance of it, which is expected. SELECT MyTable.field1, MyTable.field2...

Hi, I am trying to pull records from tables which have the same dates within a field in a table. For example if a table has following records: Field_1 Field_2 ref1 date1 ref2 date2 ref3 date3 ref1 date2 The query should output only 2...

Hi, Thank you for your replies. I have followed George's method and used First or Last instead of Min() or Max() and it worked. Thanks again

Thanks for a reply, In this particular query I do not mind which one to drop (also to make things simpler). How can I use Max() or Min() when I have my data as a text and not as numbers? Is this possible, if yes can you please be more specific? Thanks you

Hi, I searched all the mails with this subject, but still do not have a difinate answer. I would like to eliminate duplicates within a field in a query with other fields been distinct. So for example: Col1 Col2 Col3 ref1 val1 val2 ref2 val10 val11 ref2 val5 val11 ref3...