[AccessD] Missing Issues Query

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.

GK

On 8/17/07, Bryan Carbonnell <carbonnb at gmail.com> wrote:
> Good Day folks,
>
> HELP!!!
>
> It's been so long since I've done anything in Access that I can't even
> begin to think of how to create this query.
>
> What I'm looking for is similar to a "Missing Check" report in
> Quickbooks, you know one that lists all of the check numbers that
> aren't there.
>
> What I have is a DB for all my National Geographic Magazines (and
> eventually all my other assorted magazines) and I'm trying to create a
> query (and eventually a report) that lists all the issues that are
> missing.
>
> Right now, what I have is a table:
> iss_ID
> iss_Magazine_FK
> iss_Volume
> iss_Number
> iss_Date
>
> iss_Magazine_FK is a FK to the name of the Magazine held in another
> table (currently it is only holding a value of 1 since I only have 1
> Magazine available to choose from)
> iss_Volume is an integer that holds the Volume number (1-212)
> iss_Number is an integer that holds the Issue Number (1-6)
> iss_Date is a date/time that holds the date of the issue
>
> How do I even begin to start to write this query?
>
> --
> 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