[AccessD] Reference Material

Mitsules, Mark S. (Newport News) Mark.Mitsules at ngc.com
Wed Aug 25 10:19:02 CDT 2004


Thanks Dan, that is a consideration...


Mark



-----Original Message-----
From: Dan Waters [mailto:dwaters at usinternet.com] 
Sent: Wednesday, August 25, 2004 11:00 AM
To: 'Access Developers discussion and problem solving'
Subject: RE: [AccessD] Reference Material


Mark,

Another path you might consider is to use Excel with Automation.  Excel has
a world of statistical functions available.  

I would start by creating what you want in Excel using the worksheet
functions.  Then automate Excel from Access and place the functions you want
in the spreadsheet using code.  Then you can retrieve the value(s) you want
from that spreadsheet, then close Excel.  This lets Excel do the calculation
work instead of trying to do it in Access.

When you open Excel from Access, it will not be visible on screen (unless
you specify that it be visible).  So the user doesn't see any extraneous
screen activity.

Hope this helps,
Dan Waters
ProMation Systems, Inc.

PS - you can use MS Graph in Access reports in addition to Office Web
Components.

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Mitsules, Mark S.
(Newport News)
Sent: Wednesday, August 25, 2004 8:14 AM
To: [AccessD]
Subject: [AccessD] Reference Material

Group,

Can anyone suggest some reference material that discusses developing
sophisticated Access reports which will include statistical analysis and
graphing?


Mark
-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

-- 
_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com



More information about the AccessD mailing list