LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Manipulation of Data extract from Access Database Chase Excel Discussion (Misc queries) 2 July 19th 07 07:42 AM
Convert MS Excel data to MS Access database HelpJim Excel Worksheet Functions 6 January 2nd 06 03:51 PM
Excel as Data Entry into Access Database Btibert Excel Discussion (Misc queries) 3 August 29th 05 02:17 PM
excel to get data from an access database confused Excel Discussion (Misc queries) 1 February 18th 05 06:29 PM
Excel 97 - extract data from COMBO BOX to Database daneman007 Excel Programming 0 August 11th 04 09:03 PM


All times are GMT +1. The time now is 09:40 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"