View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
John John is offline
external usenet poster
 
Posts: 141
Default Extract Data from an Access Database in to Excel

There is a facility within Excel to extract Data based on parameters in to
Excel. I use this and it works great based on one parameter. But is it
possible to set 2 parameters to work from. It seems obvious but I can't get
it to work.

My scenario is that at the moment I extract from a Timeclock database
between 2 dates (from and to fields), but I only need the data from a
certain employee, between the dates I select. I have a cell where this
employess number is - A2, based on what I do to extract the specified dates,
I've added another criteria, but it doesn't work - can it?

Thanks