survey count

[enrico via AccessMonster.com]

i created two tables(tblClient and tblResult). tblClient is for a particular
respondent and tblResult is consists of the answers(which the questions are
only posted on my form) and represented on my table as A1, A2, A3, and so on.
how do i create a survey out of this, like the count of clients who answered
"Agree" in data A1?

 

[Allen Browne]

Whereever you see repeating fields (such as A1, A2, A3, ...), it always mean
your table is not normalized. You need to create a related table to hold the
answers as many records, instead of as many fields in one table. You will
then be able to count the values for each answer.

For an example of how to set up a question'n'answer database like that, see
Duane Hookom's At Your Survey database:
http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=3

 

[enrico via AccessMonster.com]

actually, i only represent my questions with A1, A2, etc. because it would be
tiring to code it in my INSERT statement. the fields will be answer. i've
already seen the sample and it's too advance and complicated for me. i only
want to create a simple date entry and retrieval

 

[Allen Browne]

Please understand that by using a flat-file table (what you call 'simplying'
the design), you are creating something that is very hard to query (as you
found.)

 

[Piet Linden]

i created two tables(tblClient and tblResult). tblClient is for a particular
respondent and tblResult is consists of the answers(which the questions are
only posted on my form) and represented on my table as A1, A2, A3, and soon.
how do i create a survey out of this, like the count of clients who answered
"Agree" in data A1?

why not just use Duane Hookum's At Your Survey?