Search results

  1. P

    Comparing calls statistics

    OK, So I suspect I'm not being specific enough. Let me start again. We have 2 tables Table 1 contains what we are being invoiced for Table 1 04/05/2011 15:09:59 4 08708896893 D UK NationalRat 0.0045 Special Services (nr) 04/05/2011 15:10:05 4 08708896893 D UK NationalRat 0.0045 Special...
  2. P

    Comparing calls statistics

    Hi, I need to compare call data between our network carrier and the calls over the same period on our call logger. Obviously, I can't provide too much information. So our "network carrier" will provide the attached fields. And our call logging device will provide the attached "call detail"...
  3. P

    Separating data within a table

    Brilliant, it took a little while working out how to use the DateValue and TimeValue expressions within my query but it works very well. It has separated out the date and time without impacting on the table data. Many thanks for your help.
  4. P

    Separating data within a table

    Hi, Surprise, surprise, I'm new to this forum, and have a million silly questions. But I shall start at the beginning. I have imported some data with around 10 coulmns. In one of these columns is the date/time. I need to separate this information, and enable me to append my existing table...
  5. P

    Newbie yet oldie

    Hi, I have been registered on this site for some time, but have never really used it before. I'm a telecoms industry working to reviews my companies call data. Typically it can be around 500,000 calls reviewed on any one date. I have been using access for the past 10 years but never got to the...
  6. P

    Hi All

    Hi All, I'm pretty new to the world of access. I have found access to be very useful as I have been asked to review data normally in access, but the data could be well over 200000 rows which tends to slow down my PC, which in turn makes me less productive. I work in IT in London, with very...
Top Bottom