Help with a report query

Discussion in 'Databases' started by VanillaWafers, May 20, 2010.

  1. #1
    My company is using switchbox for our phones and call logs. They give us a bunch of reports but it is very unorganized and I am wanting to run some queries to sort things out.

    Right now I am wanting to find the incoming calls that were not made by people in the building.

    For example if the call came from the building it will look like

    Fred Breyer <153>

    if it did not come from the building then it will look like

    7184753700 <7184753700>

    I am wanting to exclude all calls from the building.

    How would I set up my query.

    Thanks
     
    VanillaWafers, May 20, 2010 IP
  2. jestep

    jestep Prominent Member

    Messages:
    3,659
    Likes Received:
    215
    Best Answers:
    19
    Trophy Points:
    330
    #2
    Is this data from a database or a flat file?
     
    jestep, May 20, 2010 IP
  3. VanillaWafers

    VanillaWafers Greenhorn

    Messages:
    79
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    18
    #3
    It is exported into an excel file that I am opening in access
     
    VanillaWafers, May 20, 2010 IP