Updating table from crosstab query

  • Thread starter Thread starter Chad
  • Start date Start date
C

Chad

Hopefully this will be an easy question. I haven't played
around with this too much because I am not sure the route
to go. Here is my problem:

I would like to update a table with data in the format of
a crosstab query. I know that sounds confusing but let me
give you an example:


01/01 02/01 03/01
Program1 6 15 7
Program2 9 22 13


I would like to use this information to update a table the
has the fields:

Table1:
Month
Program
Actuals

I know how to create the crosstab query to display
information in the format above but I am not sure as to
how to insert this data as a new record(s) into this table.

Can someone please help?

Thanks,
Chad
 
Crosstab queries aren't updateable. You could push the data to a temporary
table, update the table, and then push the changes back to your normalized
table. Or, you could create a totally unbound form to display the results.
As text boxes are updated, you will need code to update the table.

Tom Ellison has some experience with doing this with ADPs but I don't think
the same will work with an MDB.
 
Back
Top