J
Joe
I'll just come out and say what it's for... it's for my comic book
collection. And here's the situation. I have four linked tables that are
linked in the following order:
[Publisher] ->
[Title] ->
[Issue] ->
[Book]
In the issue table it holds the info for each issue for each title for each
publisher. The key is simply an autonumber.
What I want to do is to be able to run a query that will tell me [based on
#1 being the first issue - whether #1 is entered or not - and the highest
number I have listed being the last] what issues I'm missing. There is one
problem with the whole thing as some titles will have mutiple #1's due to
reprints/variants and whatnot.
Thanks for any help!
collection. And here's the situation. I have four linked tables that are
linked in the following order:
[Publisher] ->
[Title] ->
[Issue] ->
[Book]
In the issue table it holds the info for each issue for each title for each
publisher. The key is simply an autonumber.
What I want to do is to be able to run a query that will tell me [based on
#1 being the first issue - whether #1 is entered or not - and the highest
number I have listed being the last] what issues I'm missing. There is one
problem with the whole thing as some titles will have mutiple #1's due to
reprints/variants and whatnot.
Thanks for any help!