I have access 2000. My program is about filling wine bottles.
I have a crosstab query that returns the number boxes of each kind of cork we will use (based on the number of bottles we will fill) Like this:
ALTEC 177
CHAMPAIGN 3
N44 104
The names of the corks are the ROWS.
I have another table called warehouse. In that table I have fields(=COLUMNS) for each cork. "ALTEC","CHAMPAIGN",N44. And the warehouse lists quantities presently there.
How does one build an action query for this case? For instance, I want to update the warehouse by subtracting the corks needed. The remainder is how much to order.
I have a crosstab query that returns the number boxes of each kind of cork we will use (based on the number of bottles we will fill) Like this:
ALTEC 177
CHAMPAIGN 3
N44 104
The names of the corks are the ROWS.
I have another table called warehouse. In that table I have fields(=COLUMNS) for each cork. "ALTEC","CHAMPAIGN",N44. And the warehouse lists quantities presently there.
How does one build an action query for this case? For instance, I want to update the warehouse by subtracting the corks needed. The remainder is how much to order.