Darryl Collins
darryl at whittleconsulting.com.au
Mon May 7 19:34:49 CDT 2012
Hi Charlotte, Just to clarify, the data is already in an Access database, you need to create a chart / report in Excel based on a sub set of data from Access? The linking between access and Excel won't be an issue and there are a few ways to do it (each have their pros and cons). The subset seems to consist of a few parameters Start and end Dates (or Months) which are dynamic Does the "claim avoided" sit with the same data point as "Recovered" - same datapoint, different status sort of thing? If you can send me a sample of the data I can try and have a play with it for you. Cheers Darryl. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust Sent: Tuesday, 8 May 2012 9:36 AM To: Access Developers discussion and problem Subject: [AccessD] Plotting datapoints to Excel The company I contract to has a state mandated Excel report that consists of data points entered as values by month incurred (down) and month recovered (across). I'm trying to figure out a reasonably fast way to compile the data in the Access database where it's captured but I'm banging my head against a wall just trying to get my arms around the spreadsheet. (It is Monday, after all!) The data points would be compiled from information on cost recovery and avoidance, so we're looking at the month the cost was incurred (claim filed) and the month cost was avoided (claim denied) or recovered (somebody else paid up). This is a progressive report, so it starts at an arbitrary month and year and ends some indeterminate years later. For now we're simply dealing with March 2012 going forward. Ignoring the rules on how we know whether or not to report a specific claim, anyone have any brilliant suggestions on how to parse out the data points? I'm running on empty today. Charlotte Foust -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com