P
pat67
Hi, I have a table that i link from access to excel. I am trying to
subtotal the table. I can add a Column no big deal. But I need to be
able to add rows. When I do it manually and then refresh the table,
all the manual work goes away. Is there a way to do what I need in
either excel or in a table or query in access?
Thanks.
Here is the data table
Extraction Date Evaluation Prd Line Stock Value Prd
Order PO Value Req Value
4/15/2011 GENUINE $48,338 $158
$105,548 $0
4/15/2011 GENUINE 6 $6,042,343 $27,190 $94,818 $7,673
4/15/2011 GENUINE 19 $965,482 $0
$54,239 $0
4/15/2011 POTENTIAL $99,848 $0 $60,000
$0
4/15/2011 POTENTIAL 6 $2,322,531 $28,979 $782,234
$156,283
4/15/2011 POTENTIAL 19 $1,543,077 $0 $250,657 $19,136
4/15/2011 NONALIGNED 6 $6,857 $0 $32,006
$5,827
4/15/2011 NONALIGNED 19 $743,969 $0 $22,829
$0
4/15/2011 $1,008,476 $3,067 $266,600 $7,484
4/15/2011 6 $4,697,716 $205,885 $2,642,633 $963,008
4/15/2011 19 $1,673,071 $5,594 $908,890 $113,120
subtotal the table. I can add a Column no big deal. But I need to be
able to add rows. When I do it manually and then refresh the table,
all the manual work goes away. Is there a way to do what I need in
either excel or in a table or query in access?
Thanks.
Here is the data table
Extraction Date Evaluation Prd Line Stock Value Prd
Order PO Value Req Value
4/15/2011 GENUINE $48,338 $158
$105,548 $0
4/15/2011 GENUINE 6 $6,042,343 $27,190 $94,818 $7,673
4/15/2011 GENUINE 19 $965,482 $0
$54,239 $0
4/15/2011 POTENTIAL $99,848 $0 $60,000
$0
4/15/2011 POTENTIAL 6 $2,322,531 $28,979 $782,234
$156,283
4/15/2011 POTENTIAL 19 $1,543,077 $0 $250,657 $19,136
4/15/2011 NONALIGNED 6 $6,857 $0 $32,006
$5,827
4/15/2011 NONALIGNED 19 $743,969 $0 $22,829
$0
4/15/2011 $1,008,476 $3,067 $266,600 $7,484
4/15/2011 6 $4,697,716 $205,885 $2,642,633 $963,008
4/15/2011 19 $1,673,071 $5,594 $908,890 $113,120