R
Ranjit kurian
Is it possible to give If function in ms access query by using column
numbers(R1C1 references which we have in excel).
i have a table by which one crosstab query is created, every month the
heading of the query result will change because the heading is a month, till
the crosstab query everything is fine no problem, now i need to create a
separate simple query using the above said crosstab query where i have to use
the IF functions as the heading which is not constant, can i use the column
number to write IF function, so that the same action need to be performed on
that set of columns irrespective of header changes.
numbers(R1C1 references which we have in excel).
i have a table by which one crosstab query is created, every month the
heading of the query result will change because the heading is a month, till
the crosstab query everything is fine no problem, now i need to create a
separate simple query using the above said crosstab query where i have to use
the IF functions as the heading which is not constant, can i use the column
number to write IF function, so that the same action need to be performed on
that set of columns irrespective of header changes.