Re: Get deleted primary keys

Erico Vasconcelos <EricoVasconcelos@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

1) I have a members table. It has member ID column as primary keys. It has
1000 members. Some members has been deleted, so our table has some slots in
the member ID sequence. I would like to create a report containing the
deleted members ID (the ones that do not exist anymore).

FWIW I would never delete members. Instead I have an Inactive Yes/No
field or an Inactive status field.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
.

Relevant Pages

  • Re: Orlow cardinality question
    ... >> members in an arbitrary finite set. ... >> some member of the sequence) of, for decimal numbers, either the ... >> naturals, it says nothing about the set itself. ... Meaning that there is a standard set, ...
    (sci.math)
  • Re: Orlow cardinality question
    ... A set is a number of elements, members, units, or whatever. ... > some member of the sequence) of, for decimal numbers, either the ... I have talked about the two unit infinities and the ability to classify all ... >> Yeah like the entire set of naturals. ...
    (sci.math)
  • Re: Objection to Cantors First Proof
    ... are guaranteed that we will keep finding end-points for further ... members of the original sequence from which the a_n and b_n were ... end-point, a_oo, would be an omega-th entry of the sequence, so nothing is ... What My proof demonstrates is that, given any sequence of reals, there ...
    (sci.math)
  • Re: Disjoint sequence with subsequences converging to points in the cantor set
    ... such that the members of S are not also members of C, ... you cannot make a sequence out of ALL such numbers. ... "If subsequence of the set"... ... Do you have a collection of open subintervals (subintervals ...
    (sci.math)
  • Re: Objection to Cantors First Proof
    ... are guaranteed that we will keep finding end-points for further ... members of the original sequence from which the a_n and b_n were ... end-point, a_oo, would be an omega-th entry of the sequence, so nothing ... Except that you have assumed, per absurdo, that the reals are countable. ...
    (sci.math)