View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Don MacKinnon Don MacKinnon is offline
external usenet poster
 
Posts: 1
Default How to get Excel to retrieve aggregate data from Access

I'm trying to get aggregate data (SUM) from a multitable .mdb in Access using
an Excel VBA macro. The aggregate uses three tables and four or five limiting
criteria. I'm simply trying to retrieve a single aggregate figure from Access
rather than a worksheet full of data that requires further Excel calculations.