cross tab insert

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Back
Top