total text box field results

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table with 3 fields formatted as text, they all have 3 choices from
a combo box, "yes", "no", "DNA". How can i total the individual reponses from
each field.
 
SELECT tblTest.Test1 AS TheText, Count(tblTest.Test1) AS TheCount,"Test1"
FROM tblTest
GROUP BY tblTest.Test1
UNION ALL SELECT tblTest.Test2, Count(tblTest.Test2), "Test2"
FROM tblTest
GROUP BY tblTest.Test2
UNION ALL SELECT tblTest.Test3, Count(tblTest.Test3),"Test3"
FROM tblTest
GROUP BY tblTest.Test3;

When you find yourself having to do things like this, it usually indicates a
flaw in the design of the database.
 
Back
Top