Results 1 to 4 of 4
  1. #1
    vishwanaib is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Oct 2016
    Posts
    2

    Question Using Access to detect trends in data

    I have a database of mobile numbers (some 2 million +),
    each has done specific kind of recharge ( around 8 types), and revenue for particular month, I have this data for 3 months
    These recharges are done multiple times and some numbers have done multiple types of recharges in same month.




    I have to check if there is any trend in this data like

    - increase in revenue after selection of particular pack?
    - trend of pack selection over months


    this all can be done easily in excel but can’t import this to excel, also i have very limited knowledge of access.
    I tried using power pivot in excel but the pivot output also exceeds rows in workbook ( around 1 million)

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    not sure if it meets your needs or whether it was deprecated in 2013 but have you tried the pivot or chart view of a table or query? (leftmost dropdown on ribbon)

  3. #3
    vishwanaib is offline Novice
    Windows 7 64bit Access 2013 64bit
    Join Date
    Oct 2016
    Posts
    2
    I tried it but it helps me to analyse particular months data. Not across the month.

  4. #4
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    sounds like you need to be using a query and break the dates down to weeks/days etc

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

Similar Threads

  1. Replies: 5
    Last Post: 09-09-2016, 09:23 AM
  2. Replies: 4
    Last Post: 05-14-2014, 10:03 PM
  3. Need to detect right arrow key
    By ChuckColeman1812 in forum Programming
    Replies: 4
    Last Post: 09-12-2012, 08:08 AM
  4. VBCode to detect Access 2003 vs 2007?
    By Angelsnecropolis in forum Access
    Replies: 11
    Last Post: 08-01-2011, 04:18 PM
  5. VBA/Access form Detect return of software
    By superfury in forum Programming
    Replies: 1
    Last Post: 07-06-2011, 07:52 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