[AccessD] Plotting datapoints to Excel

Charlotte Foust charlotte.foust at gmail.com
Mon May 7 23:11:44 CDT 2012


No, the data is pulled from a mainframe report.  The sum of the costs
avoided/recovered is entered at the intersection of the month/year the
claim was filed and the monthyear the claim was denied or cost was
recovered.  Believe me, the documentation is even more confusing.

Charlotte

On Mon, May 7, 2012 at 6:08 PM, Susan Harkins <ssharkins at gmail.com> wrote:

> They enter the same data twice in the same data set? How is it stored in
> Access, once or twice?
>
> Susan H.
>
>
>
>  The summary data is inserted at the intersection of the month/year of the
>> claim and the month/year of the denial, cost avoidance or recovery>  Does
>> that make it any clearer?  I'm working from a template worksheet that poor
>> users would otherwise have to fill in by hand and it isn't a chart, it's a
>> kind of aging report.  To simplify, if a claim was filed in Jan 2012 and
>> denied in Mar 2012, the amount billed and not paid would be entered in the
>> Jan2012 column and the Mar 2012 row.  The actual record contains both
>> dates
>> and all the various amounts billed, paid, recovered, etc..  I feel like
>> I'm
>> looking at this backwards and it should have a simple solution, but at the
>> moment, I'm covering someone else's job while trying to do my own.
>>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/**mailman/listinfo/accessd<http://databaseadvisors.com/mailman/listinfo/accessd>
>
>
> Website: http://www.databaseadvisors.**com<http://www.databaseadvisors.com>
>
>
>


More information about the AccessD mailing list