[AccessD] Missing Issues Query

OOps. Guess I didn't read your question very well. How about if you
make a working table with all the volume numbers for each magazine
then. Then do what I said before.

GK

On 8/17/07, Bryan Carbonnell <carbonnb at gmail.com> 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.
>
> --
> Bryan Carbonnell - carbonnb at gmail.com
> Life's journey is not to arrive at the grave safely in a well
> preserved body, but rather to skid in sideways, totally worn out,
> shouting "What a great ride!"
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


-- 
Gary Kjos
garykjos at gmail.com