Recent content by clintthorn

Forgot to add that when I try to implement what you said earlier, It give me a 'type mismatch in expression' when I join on both country and month

I tried that but still couldn't get it to work. It is probably because it is a bit more complicated than what I said. I am using a query to roll up some of the data. I also need to multiple the 'installed' and 'activation rate' by a bounty that is country specific. Here is my query without the...

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...

Here is a toned down sample of the query and activation table. The two are joined on 'New Country' and 'ActCountry'. He is the SQL that is currently being used: SELECT Month([date]) AS [Month], Convert_Query.Date, Convert_Query.Source, Convert_Query.Client, Convert_Query.Product...

It works fine for the July data, but the August data uses July's activations for the calculations.

The fields for country are in the same format. For the month I am not sure. In the query it is pulled out of the date field via: Month([Date]) AS [Month], while the activation table I just entered the numerical value for the month (e.g., 7 for July). Would I replicate the formula in the...

I thought that might be the case. Do you know how I could join the query and table together? I tried joining on both month and country but it will not let me.

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...

Great! It worked Thanks for you time and help!

I cannot get it to work. The query I have is a select query. Do I need to create a separate query to do this? Or just put the code in a specific place? Thanks for the help.

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 didn't even think of deleting them. Leave it to me to try and complicate things. :) Do you know a way that I could delete all the rows that have blanks in a specified field? I import data daily into access, and there are 50k+ rows a day. I can sort the column to have a the blanks together...

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...

Wayne, I tried Right Join and it shows the fields that have a blank geo. However, it doesn't populate them with "Other" Here is the actual code (previous just simplified, probably should have shown the original in the first place:)): SELECT [2008_Q3_DLP_Table].DATE, Geo_Table.Geo...

I am not sure if the join is correct I saw somewhere that I needed to use "outer join" or "left outer join." It would not let me use "outer join." I tried the Nz (), but it doesn't work. I pull the data into pivot table in excel and it tells me [Microsoft][ODBC Microsoft Access Driver]...