[AccessD] Export To Excel - Formulas Possible?

Lawrence Mrazek lmrazek at lcm-res.com
Mon Nov 21 12:34:11 CST 2005


Thanks Ken:

Is this feature built-in to Excel, or do I tap into it via VBA? 

Larry Mrazek
LCM Research, Inc.
www.lcm-res.com
lmrazek at lcm-res.com
ph. 314-432-5886
fx. 314-432-3304

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Ken Ismert
Sent: Monday, November 21, 2005 11:44 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Export To Excel - Formulas Possible?

 
>> Does your approach adapt to data that might have 5 groups one month, 
>> then 10 the next?

In that respect, it works like a standard Access report: once you define a
group (month), and a subgroup, the subgroup will repeat as many times as
neccessary under the group. 

So, if your query is groupable by an Access report, it is groupable using
the Excel report tool.

-Ken

--
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