L
ljh3rdid
Hi!
Just wondering if and how I could filter results information from a pivot
table into Access? My objective is to filter out certain criteria, pulling
only the results of the numbers into the table. Here's the catch: I'd like
to be able to readjust the pivot table and pull into that same table the
different results based on that adjustment.
OR Is there a way to do this by importing the raw data straight into Access
from Excel, then doing an "if, then" statement in Access (ie, if results from
one column are "Y", then go to "theresults" column?
If so, how?
Thanks in advance,
Lesley
Just wondering if and how I could filter results information from a pivot
table into Access? My objective is to filter out certain criteria, pulling
only the results of the numbers into the table. Here's the catch: I'd like
to be able to readjust the pivot table and pull into that same table the
different results based on that adjustment.
OR Is there a way to do this by importing the raw data straight into Access
from Excel, then doing an "if, then" statement in Access (ie, if results from
one column are "Y", then go to "theresults" column?
If so, how?
Thanks in advance,
Lesley