Results 1 to 4 of 4
  1. #1
    Star Lounger
    Join Date
    Dec 2001
    Location
    Rickmansworth, Hertfordshire, United Kingdom
    Posts
    83
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Subtraction (97)

    I have a table comprising the numbers 1 to 8000. I have a second table of 1500 random numbers in the range 1-8000. I want to subtract these numbers from the first table to leave a table of 6500 numbers. Can Acces do it?

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Subtraction (97)

    Do you mean you want to delete the records containing the 1500 random numbers? If so, a Delete query should do the trick nicely. Simply do a join between the two tables, and make the query a Delete query. Hope this helps.
    Wendell

  3. #3
    Star Lounger
    Join Date
    May 2001
    Location
    Ventura, California, USA
    Posts
    54
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Subtraction (97)

    Or, if the 'deletion' is only temporary, I think you could use an unmatched query (there's a wizard for that).

  4. #4
    Star Lounger
    Join Date
    Dec 2001
    Location
    Rickmansworth, Hertfordshire, United Kingdom
    Posts
    83
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Subtraction (97)

    Thanks guys. I'll follow up those leads.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •