Results 1 to 6 of 6
  1. #1
    Lounger
    Join Date
    Aug 2001
    Location
    Chewelah, Washington, USA
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Comparing the same data from different sources (Access 2002)

    Request help in determining the best way to design a database. We receive faxes from an organization and then, once a month, receive an itemized bill listing most of those faxes. I would like to set up a database comparing the received faxes with the bill. The faxes list

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    San Francisco, California, USA
    Posts
    358
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comparing the same data from different sources (Access 2002)

    Could you do an update query to update the contents? You can use the Format function to format what you're updating to.

    From Help, Format(Time, "Long Time")

    So it would look like Format([MyField],"Long Time") (or short time, if that's the direction you're going).


    HTH,

    Cecilia <img src=/S/smile.gif border=0 alt=smile width=15 height=15>

  3. #3
    Lounger
    Join Date
    Aug 2001
    Location
    Chewelah, Washington, USA
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comparing the same data from different sources (Access 2002)

    Cecilia,
    Thanks. Everything right now is on paper. I can get the itemized bill from our contractor in Excel. The faxes I'll just type in. That won't take very long. Thank you for the prompt response. Now, that I know how to at least solve the time problem, I'll start typing.

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

    Re: Comparing the same data from different sources (Access 2002)

    Your biggest challenge is going to be matching up faxes from the two documents, as you don't have consistent times. Do you have a sending phone number that would help establish a common key for the records?
    Wendell

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    San Francisco, California, USA
    Posts
    358
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comparing the same data from different sources (Access 2002)

    Oooops! Sorry, I misunderstood. I thought you had two databases, or at least electronic versions of the data. That sounds like an awful lot of typing. I'm physically, morally, and mentally opposed to that much typing....

    Cecilia :-)

  6. #6
    Lounger
    Join Date
    Aug 2001
    Location
    Chewelah, Washington, USA
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Comparing the same data from different sources (Access 2002)

    Wendell and Cecilia,
    Thanks for the replies. The contractor handles crisis calls that come in on one specific phone number, so that isn't a factor. As to typing all the faxes in, that really isn't a problem. That is generally what I do all day. It will only take a couple of days. And, it is worth it. My boss doesn't like wasting money and it appears that for one month some unknown entity mis-programmed their fax dialer and called our special phone number over 50 times. If a call lasts more than 30 seconds, we pay $10 to $11 per call regardless of content. If I can get the data in a useable format, she can negotiate a way to handle erroneous calls without them running up our bill and some other issues that have come up.

    What I would like is some way to compare one day's worth from each table and then update a field in each to link them. But, right now, knowing a way to handle the time disparities is sufficient.

Posting Permissions

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