Search results

  1. V

    Count and Percentage

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

    Question on MS Kb article - updating and appending records with one update query.

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

    Convert a Row to one column.

    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!
  4. V

    Updating 10 Random Records in a Table.

    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...
Back
Top Bottom