Results 1 to 4 of 4
  1. #1
    RDJ is offline Novice
    Windows 10 Access 2016
    Join Date
    Dec 2019
    Posts
    1

    Question Filling in numbers in design

    I am trying to create a data base of a phone system that I am responsible for. I have it dumped into an excel spreadsheet and plan on importing it into access. the phone numbers range from 6000 to 7025. there are LOT of numbers that are not used and they are spread all throughout the range. what I want to do is fill in the missing numbers without having to reenter the data on the used numbers. Once the database is finished I want to run a query that will output the data in a number of ways, one of which is a list of unused numbers. is this possible either in excel or in access? I have the info imported into a basic table already.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    You can run some vb code to create a list of all numbers.
    then compare it to your Imported #s.

  3. #3
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    Quote Originally Posted by RDJ View Post
    I have it dumped into an excel spreadsheet and plan on importing it into access
    Did the export include the name attached to each of the the phone numbers?
    Yes, using queries, you can output the results however you want in reports.

  4. #4
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    12,737
    Code would certainly be one way. Another:
    - link to the spreadsheet from Access
    - in a spreadsheet column (not the linked one) drag to fill a numeric list from 6000 to 7025.
    - paste append (Access Ribbon) that column into the table you'll use for the data (would contain the same fields as your spreadsheet columns). You should get a numeric list
    - create a query to update the table with the linked spreadsheet column data
    - the table fields (name, etc) get updated with the spreadsheet data for each number that matches in each. Table numbers that don't exist in the spreadsheet will remain blank. As I read the post, you want a complete ascending list from one starting to one ending number but have the name data for those numbers that are in your source data.
    Last edited by Micron; 12-13-2019 at 10:53 PM. Reason: clarification
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 14
    Last Post: 09-06-2019, 06:19 PM
  2. Replies: 1
    Last Post: 03-09-2016, 10:58 AM
  3. Replies: 1
    Last Post: 06-09-2015, 10:04 AM
  4. Replies: 8
    Last Post: 03-10-2014, 11:47 AM
  5. Replies: 1
    Last Post: 11-29-2011, 08:43 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums