IF Function

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

query to identify the column headings 3
Help on crosstab query 2
Query a crosstab query 2
Crosstab Query Column headings 4
Crosstab By Date (Month) 5
What Kind Of Query Can I use? 6
Make-table query with around 2 ml records taking too long 0
merge 2 crosstab tables without key 2

Top