H
hamking
I have table1 consisting of weeks, trend, qty, fillrate. weeks and
trend are filled in via an append query from a table2. the qty and
fillrate fields are currently blank in table1 but will be needed to be
updated via an update query from table3 and table4. Table1 is linked
to an excel spreadsheet so that I can chart a trendline by trend, qty,
and fillrate comparison (weeks will be the x-axis).
The trend data for all 52 weeks is complete so I have already append
the data into table. As qty and fillrate data are received for each
week the data should be updated into table1 so that the linked excel
sheet will automatically chart the additional data for each week. I
already have a macro to run weekly and excel charting the 3 stats.
However, my update query is always stating "Operation must use an
updateable query". This is the first time I'm using an update query
so I don't know if what I need is possible. Can someone please help.
Following is the setup:
Table2
Week Trend
1 .3
2 .5
3 .9
Table3
Week QTY
1 50
2
3
Table4
Week Fillrate
1 .8
2
3
Table1
Week Trend QTY Fillrate
1 .3 50 .8
2 .5
3 .9
Thus, update query will update Table1 QTY and Fillrate for week 2 and
3 when data is input into Table3 and Table 4.
trend are filled in via an append query from a table2. the qty and
fillrate fields are currently blank in table1 but will be needed to be
updated via an update query from table3 and table4. Table1 is linked
to an excel spreadsheet so that I can chart a trendline by trend, qty,
and fillrate comparison (weeks will be the x-axis).
The trend data for all 52 weeks is complete so I have already append
the data into table. As qty and fillrate data are received for each
week the data should be updated into table1 so that the linked excel
sheet will automatically chart the additional data for each week. I
already have a macro to run weekly and excel charting the 3 stats.
However, my update query is always stating "Operation must use an
updateable query". This is the first time I'm using an update query
so I don't know if what I need is possible. Can someone please help.
Following is the setup:
Table2
Week Trend
1 .3
2 .5
3 .9
Table3
Week QTY
1 50
2
3
Table4
Week Fillrate
1 .8
2
3
Table1
Week Trend QTY Fillrate
1 .3 50 .8
2 .5
3 .9
Thus, update query will update Table1 QTY and Fillrate for week 2 and
3 when data is input into Table3 and Table 4.