editing a crosstab query

R

radioheadbutt

I am having difficulty editing a crosstab query - and I believe another
question was asked about this - but I'm not sure if it was ever answered.
When I try to edit an individual cell, I cannot edit the information. Any
suggestions?

PARAMETERS [Forms]![frm_paula]![cbo_mp] Long;
TRANSFORM First(tbl_ImpactReal.Value) AS FirstOfValue
SELECT SubProcess.SubProcess
FROM tbl_Category INNER JOIN (SubProcess INNER JOIN tbl_ImpactReal ON
SubProcess.SubProcess_ID = tbl_ImpactReal.SubProcess_ID) ON
tbl_Category.Category_ID = tbl_ImpactReal.Category_ID
WHERE (((SubProcess.MasterProcess_ID)=[forms]![frm_Paula]![cbo_Mp]))
GROUP BY SubProcess.SubProcess
PIVOT tbl_Category.Category;

Thanks!
 
D

Duane Hookom

I just posted some code (a couple hours ago) to the question in this news
group with a subject of "Pivot Table". The code would loop through a
recordset to place values into an unbound form. I didn't include code to
write the edited values back to a table since I wasn't sure the OP would
understand the first code.

--
Duane Hookom
MS Access MVP
--

Roger Carlson said:
Crosstab queries cannot be edited.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

radioheadbutt said:
I am having difficulty editing a crosstab query - and I believe another
question was asked about this - but I'm not sure if it was ever answered.
When I try to edit an individual cell, I cannot edit the information.
Any
suggestions?

PARAMETERS [Forms]![frm_paula]![cbo_mp] Long;
TRANSFORM First(tbl_ImpactReal.Value) AS FirstOfValue
SELECT SubProcess.SubProcess
FROM tbl_Category INNER JOIN (SubProcess INNER JOIN tbl_ImpactReal ON
SubProcess.SubProcess_ID = tbl_ImpactReal.SubProcess_ID) ON
tbl_Category.Category_ID = tbl_ImpactReal.Category_ID
WHERE (((SubProcess.MasterProcess_ID)=[forms]![frm_Paula]![cbo_Mp]))
GROUP BY SubProcess.SubProcess
PIVOT tbl_Category.Category;

Thanks!
Click to expand...
Click to expand...
 
Top