[AccessD] Missing Issues Query

Hi Bryan,
If I understand your problem correctly, you have entries only for those 
issues you possess - there are no blank issue entries.  So, you will be 
looking for a skip in the issue numbers or in the dates.  Aside from 
writing something that meanders through all the dates or some 
combination of volume-issue-date to see where the pattern breaks, would 
it work for you to use a temporary date table with the dates that SHOULD 
all be there and use that table with your issues table and do the outer 
join trick against it?  That would give you the dates that are missing 
and you could fill in the appropriate volume and issue numbers by 
inspection.  Hope that helps a little.
Tina

Bryan Carbonnell wrote:
> On 8/17/07, Gary Kjos <garykjos at gmail.com> wrote:
>   
>> Well what you are after is a left join kind of a query from the table
>> that has all the magazines go the table that has the missing ones with
>> the join option to say "give me all the records" in the table with all
>> the magazines. Then you do a condition on one of the table fields in
>> the other table to test for "IS Null" and you will only get the ones
>> that are missing.
>>     
>
> Maybe I'm missing what you are saying Gary, but I've only got 1 table,
> and that is the table with the issues of the magazine that I have. I
> don't have table with a full list of potential issues.
>
>