Need to create several tables based on the output in one field

  • Thread starter Looking for a pivot table in Access
  • Start date
L

Looking for a pivot table in Access

I deal with serveral hundred thousands of records on a daily basis and I
recently received a file that is about 400k records and I need to break them
down into separate tables based on the field of where they were sent from.
From that I have to pull out each different form and calculate how many
instances of each form and how much the total value is of each form. I guess
it would look something like this SENT FROM>DOCUMENT TYPE>Total Count/Total
Value. In Excel I would just use a pivot table but there far too many for
files for Excel(2000ver.) to handle in one sheet. Is there a way I can the
same amount of functionality out of Access? Now, I've already used code to
get them all into one master table, and I started to use a prompt query to
pull out the different SENT FROM fields, but that I realized after about
45minutes and not getting anywhere there has to be a faster way. If anyone
could give me any helpful advice even if its just how to automactically make
several tables based on the SENT FROM field it would be highly appreciated.
 
K

KARL DEWEY

Check and see if a CrossTab query will do what you want. I think it will
based on what you said.
 
S

Still in need of help

Sorry I didn't mention in my original request, but I've alreayd tried
crosstab query and it will give me a total count of records, or a total value
of records, but not the two together.
 
K

KARL DEWEY

See my post under Access Queries. Search "How to count some data percent
based on" or "Query12_crosstab"
 
Top