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

Yes it can and should work; please give details of how the query is set up
and how the parameters are being specified - plus, "it doesn't work" is
rather vague. What happens? Error message, or results are not correct, or
what?
--
- K Dales


"John" wrote:

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

Thanks K Dales for your reply

Sorry for being vague, its tricky for me to be indepth as I can only get as
far as putting in my first Criteria (date ranges) then I try to enter the
Criteria for StaffNumber, with an operator "Equals", with a value of
"Number" - which I hope then to reference within Parameters to A2, but when
I hit OKto come out a message appears "Invalid Use of Null Pointer". Thats
where I'm lost. I just assumed it was because either a) I was using 2
criteria or b) the query just doesn't like the "StaffNumber" criteria

I have set-up the query via Excels simple wizard "Get External Data", thus I
have not coded anything myself


"K Dales" wrote in message
...
Yes it can and should work; please give details of how the query is set up
and how the parameters are being specified - plus, "it doesn't work" is
rather vague. What happens? Error message, or results are not correct,
or
what?
--
- K Dales


"John" wrote:

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