Results 1 to 4 of 4
  1. #1
    app4that is offline Novice
    Windows Vista Access 2007
    Join Date
    Oct 2011
    Posts
    2

    Lightbulb looking for someone either walk me through a database build or alternatively will pay

    Hi all I am tied for time and need assistance in creating a simple enough database that captures phone numbers from an excel spreadsheet and links the phone numbers on that spreadsheet in a database to see if these phone numbers appear in another phone (for example under a different name), because i am tied for time on this i am willing to financially re-emburse someone as this would take a considerable amount of work off my already mounting to do file. As an extra it would be nice if it was friendly enough for people with very little computer experience to use it without having to stand over them for 2 days explaining every step.



    Many thanks to all who will read and reply. I value all inputs.

  2. #2
    hertfordkc is offline 18 year novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    481

    Question

    Quote Originally Posted by app4that View Post
    Hi all I am tied for time and need assistance in creating a simple enough database that captures phone numbers from an excel spreadsheet and links the phone numbers on that spreadsheet in a database to see if these phone numbers appear in another phone (for example under a different name), because i am tied for time on this i am willing to financially re-emburse someone as this would take a considerable amount of work off my already mounting to do file. As an extra it would be nice if it was friendly enough for people with very little computer experience to use it without having to stand over them for 2 days explaining every step.

    Many thanks to all who will read and reply. I value all inputs.
    You have a huge spreadsheet and you want to see if the phone numbers in it relate to more than one name
    OR
    You want to (periodically) check for duplicate references,
    OR
    ?

  3. #3
    app4that is offline Novice
    Windows Vista Access 2007
    Join Date
    Oct 2011
    Posts
    2
    the data i will be getting will be in a series of spreadsheets. ie different end users phones and i will need to compare these spreadsheets against one another to see if the same number comes up time and again.

  4. #4
    hertfordkc is offline 18 year novice
    Windows XP Access 2007
    Join Date
    Mar 2011
    Posts
    481

    I don't ha ve my Access PC at the moment, so the best I can offer is:

    Step one.... import the spreadsheets into tables. For what you are doing, I think you could import all data into a single table which has two columns, name and phone number.
    Then you can can construct a query which sorts by name and another that sorts by phone number. The query sorted by name should give you the number of phone numbers that an individual uses. The query sorted by phone number would give you all the names using that number.
    Going into a report would simplify the presentation for either query.

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

Similar Threads

  1. Add date OnChange Event - A to Z Walk Through
    By JeffG3209 in forum Programming
    Replies: 7
    Last Post: 08-12-2011, 04:40 PM
  2. Help Me Build My Real Estate Database (Please)
    By Walkinglucid in forum Access
    Replies: 12
    Last Post: 03-24-2011, 10:47 AM
  3. Help to build a ranking
    By chorbi26 in forum Access
    Replies: 0
    Last Post: 12-20-2010, 12:47 PM
  4. How to Build and do Grouping in Ad-hoc Reports
    By StudentTeacher in forum Programming
    Replies: 2
    Last Post: 10-01-2010, 01:44 PM
  5. Access Query build
    By zarfx4 in forum Access
    Replies: 3
    Last Post: 04-08-2010, 09:53 AM

Tags for this Thread

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