S
Schwimms
In excel I have 3 columns. One is job number (there are some duplicates in
here), One is Type(there are 4 categories; FNF, FNT,FNS,DNT), the last row is
total months (this is a dollar total).
I create a pivot off this; Type goes into page, job number goes into row,
and SUM of total months goes into the data field. The SUM of total months
takes the duplicates of job number and add the total.
What I would like to do is create a cross tab query in access and I am
wondering if access Sums the total months for job number the same way excel
does?
here), One is Type(there are 4 categories; FNF, FNT,FNS,DNT), the last row is
total months (this is a dollar total).
I create a pivot off this; Type goes into page, job number goes into row,
and SUM of total months goes into the data field. The SUM of total months
takes the duplicates of job number and add the total.
What I would like to do is create a cross tab query in access and I am
wondering if access Sums the total months for job number the same way excel
does?