Search results

There are 3 responses for the value 0 and no response for value 1 on 12/19/2006. Therefore Percent value is 100%. There are 2 responses for 1 and 1 response for 0 on 12/20/2006. Therefore total countofreponse = 3. Individual percentages are 2/3 (for response 1) and 1/3 (for response 0)...

I have a Query that gives me the output as follows: Code___DateofReview___Response___CountofReponse AAA____12/19/2006_____0_________3 AAA____12/20/2006_____1_________2 AAA____12/20/2006_____0_________1 AAA____1/4/2007_______1_________2 The Field "Response" can either be 0 or 1. The Variable...

I did something like this just before you posted and it worked. Your code looks much neater with a For Loop. I will make use of this. Thank you sharing a code sample!

Thanks for your response. I am feeding the output of this query to a Piechart in Access. This only takes the data as one series. Part of this problem arises due to the fact that I do not know how to create Cross Tab query in this situation. However, I will let you be the judge. I have a...

Query is too complex Error When I run the above query now, I get the error "Query is too complex" due to the multiple Union statements that I made (I think). Any ideas now to resolve this problem?

Hi, I am trying to implement an update query per the instructions at http://support.microsoft.com/default.aspx?scid=kb;en-us;127977 to append records from table2 to table1. I would like to add a criteria here saying update (and append) only records that match the criteria table2.dateofreview...

that worked. thank you!

I tried a UNION query as follows: select expr1 from qry1 UNION select expr2 from qry2 UNION select expr3 from qry3 UNION select expr4 from qry4 UNION select expr5 from qry5 This only works if all the expr values are different. If 2 or more expr have the same value they just show up once...

Hi, I have a query that outputs results as follows: Expr1 Expr2 Expr3 Expr4 Expr5 1 2 3 4 5 I want to write another query to output the above result as follows: Expr 1 2 3 4 5 Does anyone know how to do this please? Thanks!

Hi, I have following query that takes 10 random records from one table (tblaccounts) and inserts that into another table (tblrandom). SELECT TOP 10 tblaccount.*, Rnd([accnum]) AS Randnumber INTO tblRandom FROM tblaccount ORDER BY Rnd([accnum]) The above query works fine for that purpose...