Hi Gerald,

As I read your description, it doesn't sound to me as though a pivot table
is the way to go. You seem to be getting three different sets of data for a
given name, check #, and check date, and your problem is to line them up
correctly. But you're not doing any totalling, averaging, counting etc. so I
just don't see what a pivot table buys you.

My tendency would be to use three different external data ranges with your
queries (Data | Import External Data | New Database Query, foir example).
Then, if your queries return the data so that the records line up correctly
as to the duplicate name, number and date columns, you're all set;
otherwise,. a simple Data Sort should do the trick -- all you do is delete
the duplicate columns.

Not sure why duplicate rows are forcing you to run multiple queries.

As to building a pivot table from several sets of data, I think you may be
referring to Multiple Consolidation Ranges -- see the pivot table wizard's
first step.
--
C^2
Conrad Carlberg

Excel Sales Forecasting for Dummies, Wiley, 2005


wrote in message
oups.com...
I currently use pivot tables quite often and I have a situation where I
think a Pivot table would be the best solution but I am not sur eif it
is possible, or how to do it if it is possible.

I have some data which comes from my financial system through a query.
I have to run several different queries to get all of the information I
need because of duplicate rows. The first query contains an employee
name, check #, check date, net pay, gross pay, total employee
deductions and total employee taxes for the pay period. The second
query contains employee name, check #, check date and the amount of
each deduction (employee & employer with description) for the pay
period. The third query contains employee name, check # check date and
the amount each withholding (employee & employer with description) for
that pay period.

I need to somehow get all of this data into a pivot table, or if there
is another way which is better that would be fine as well, where the
final result would list the employee name, check # checkdate, net pay,
total deductions, total taxes, net pay, each deduction and each
withholding all on one line for a particular check. I think it is
possible to do a pivot table off of several different sets of data but
I am not real familiar with this, if this is even the best way to go
about this.

Any help would be GREATLY appreciated!
Gerald