jkfeagle
Codus Confusious
- Local time
- Today, 08:33
- Joined
- Aug 22, 2002
- Messages
- 166
Hello all.
Here is my dilemma. I have a query that uses the values in a crosstab query to calculate another value. Obviously this means that I have the column names in the formula. The column names represent the next 16 weeks and were originally designed simply as 1, 2, 3, 4 by my predecessor. Our company nomenclature typically uses the actual week as designation (i.e. 0102, 0202, 0302 - the first three weeks of 2002). The problem is that I want to be able to use the actual week as the week designation but then that means the formula would not be valid come the next week. An example would be that now the formulas in the query would look something like:
Expr1: [1]*[Total KG]
Expr2: [2]*[Total KG]
I want to be able to use:
Expr1: [0102]*[Total KG]
Expr2: [0202]*[Total KG]
A week later, the first week in the 16 week window would now be 0202 so that Expr1 would no longer be valid. How do I update the field names in the query that it draws the values from?? Thanks for everyone's help.
Here is my dilemma. I have a query that uses the values in a crosstab query to calculate another value. Obviously this means that I have the column names in the formula. The column names represent the next 16 weeks and were originally designed simply as 1, 2, 3, 4 by my predecessor. Our company nomenclature typically uses the actual week as designation (i.e. 0102, 0202, 0302 - the first three weeks of 2002). The problem is that I want to be able to use the actual week as the week designation but then that means the formula would not be valid come the next week. An example would be that now the formulas in the query would look something like:
Expr1: [1]*[Total KG]
Expr2: [2]*[Total KG]
I want to be able to use:
Expr1: [0102]*[Total KG]
Expr2: [0202]*[Total KG]
A week later, the first week in the 16 week window would now be 0202 so that Expr1 would no longer be valid. How do I update the field names in the query that it draws the values from?? Thanks for everyone's help.
