Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 07-21-2015, 12:14 PM
Stacyg Stacyg is offline Need to capture SQL Connected data at intervals Windows 7 64bit Need to capture SQL Connected data at intervals Office 2013
Novice
Need to capture SQL Connected data at intervals
 
Join Date: Jul 2015
Location: Boulder, CO
Posts: 1
Stacyg is on a distinguished road
Default Need to capture SQL Connected data at intervals


I have several SQL connected reports that have changing/disappearing data that I need to capture as a rolling snapshot before the data changes and disappears.

For example, I have a report that spits out PO lines that have not been released but once they are released they are no longer SQL accessible and they disappear. I know I could write another report to try to collect this based on some sort of date key but it is just not very reliable.

I want to capture the sum and count of incidents associated related to the buyer name at the end of each week in a new spreadsheet. Then the next week it does the same in a new column. I can then chart trends based on the historical data. Any easy way to do this? I am pretty good in SQL but not so much in VB and I am guessing this is the direction I will need to head. Also not interested in third party software.

Also, this data is on Sharepoint which I am just learning. There may be something with revision history based on last refresh?
Reply With Quote
 

Tags
history, sql connected



Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to capture SQL Connected data at intervals Load resources at different intervals preetsp Project 1 05-09-2014 05:36 AM
Need to capture SQL Connected data at intervals How does one receive e-mail notifications at set intervals? infobleep Outlook 7 11-29-2013 03:49 AM
Need to capture SQL Connected data at intervals Categorising values in intervals Jamal NUMAN Excel 2 07-10-2012 02:50 PM
Need to capture SQL Connected data at intervals Capture a Font in a Variable joatmon Excel Programming 1 05-30-2012 08:23 PM
Need to capture SQL Connected data at intervals Processing Time Intervals pkrishna Excel 5 09-30-2011 06:24 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:10 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft