Orchid XP v8 wrote:
> But you'd have to run the query, copy the data, paste it into Excel and 
> then fiddle about with chart options. 

This is what OLE is for, and COM.  You tell Excel to run the Access query, 
then chart the results with Excel, and skip the whole copy/paste step.


-- 
Darren New, San Diego CA, USA (PST)
   Human nature dictates that toothpaste tubes spend
   much longer being almost empty than almost full.

Post a reply to this message