Search results

I am tying to generate a query that provides revenue estimates for each log line. I am using two tables: the main data table and another for lookup values. I want to generate a revenue field that is based off the installs in the main data table. However, this is dependent on two other...

I am trying to create column that calculates revenue based off of both data within a query and another table. So far I have: IIf([Product]="CHR",[rate]*[installed]*[activation],0). The [activation] is where I am having the issue as that data is in another tab and relates to two of the fields...

I have 2 fields that are related (Distcode and Prevcode). All rows of data have distcode and prevcode values. However, so of the Prevcode values are 'UNK'. When this is the case, their value should actually equal the value in the distcode field. I know in Excel this would be a simple 'IF'...

I am trying to create a query to summarize code data (e.g., group ch0, ch1, ch2, all under ch). There are some invalid and blank codes that I want to identify as NA. I created a table that takes all the codes and classifies them into their respective groups. However, I cannot classify the blank...

I have a query that is pulling from 2 tables to help categorize the data. I have country fields that I am associating with certain geos. But there is a large list of countries that do not correlate to my geo buckets. Is there a way that I can assign a name (e.g., "other") and have them included...