How to Add a Custom Column on the result query

[nguyenak]

Hi,



Not sure if this is possible. I wanted to add an additional column on the result of a query.

For example,

Table1

Page
Visits

When I do a filter for Page ( like 'printers'), I would like the result table to be

Page
ColumnA: Page (filtered for printers)
ColumnB: Visit
ColumnC: Printers

is it possible to do this?

[alansidman]

When you filter your query on Page for "printers," what value do you want in the Column C: Printers? And if it is already filtered, wouldn't this just be redundant information of what is in column A?

[nguyenak]

in column C, I want it to display Printers.

The reason is that I will have 3 seperate queries for each division. At the end, I will merge the tables and create a pivot report

[alansidman]

In a new column, type Printers:IIF([Page]="Printers","Printers",Null)

[nguyenak]

perfecto....thank you