cross tab insert

hi
got a table with Week code, Product Code, Quantity
now i have done a crosstab with product code as row, week code as column and
quantity as value.
the only thing i need now is to insert data in the query, but the guy
doesn't let me do it.
i open to any ideia. do you think my sctructure is badly build???

thank u

A crosstab is summary information so it is not updateable. You would need to
add or edit records in the base table(s).

If you crosstab is displayed in a form, you may be able to use a
double-click event to open a dialog type form to enter the new quantity in
the table and then close the dialog form and requery the crosstab form.

--
Duane Hookom
MS Access MVP


"Roy" wrote in message
...
hi
got a table with Week code, Product Code, Quantity
now i have done a crosstab with product code as row, week code as column
and
quantity as value.
the only thing i need now is to insert data in the query, but the guy
doesn't let me do it.
i open to any ideia. do you think my sctructure is badly build???

thank u