Search results for query: *

I couldn't get that incremental value function to work. Firstly, I couldn't get it to start at 0 for each query (I needed to run 2 queries, and the numbers had to be the same for each), also, everytime I refreshed the screen, the numbers incremented again. I got around this problem by appending...

Sorry Pezamystik, but although that no longer comes up with errors, it doesn't tell me what I need to know, and it ignores a date if it is on it's own, i.e. the date both before and after is missing. You have helped me agreat deal, as I have now almost worked out a way of doing this. For my...

Sorry Pezamystik, but I can't get your example to work at all. It fails to do the (SELECT b.Date...) part and doesn't go any further. I'm gonna re-explain what I need to do. Here is a table called DATELIST name date FRED 01/01/01 FRED 01/02/01 FRED 01/05/01...

Also, as there is more than one name in the list, and each name has it's own range of dates, it is giving me the first date of a range if any other name has an earlier date.

This works fine when there is only one day missing, but when I have more than one sequential day missing, it only displays the last of the missing days. I have reversed the query to find the first of the missing days, but this creates problems. It's difficult to explain, but if it finds a...

I have a table that is simplified as thus. Name Date Jack 01/01/01 Jack 01/02/01 Jack 01/03/01 Jack 01/05/01 Jack 01/06/01 Jack 01/07/01 As you will notice, the date 01/04/01 is missing. I need to find a way of detecting...

This Worked. Thanks.

Here is a simplified version of what I am trying to do. I have a table similar to the one below, with each record having 4 fields, A, B, C, D. [A] [B] [C] [D] 1 1 2 4 8 2 7 9 6 2 3 3 5...