How do I count specific choices made from a list

[casteverole]

Hi,

I am very new to access and I am having trouble counting specific field entries.
I am trying to create a simple database to record customer feedback.

I have various fields such as "Appearance, Knowledge where the customer rates staff service.


For each of the above fields the user can choose from a drop down list "Excellent, Good, fair and poor"

How can I count the different choices made for the fields Appearance, Knowledge.
Example ; how many people chose "Excellent" for Appearance and how many chose "Good" etc..

Is using a drop down pick list the best solution?

 

[arnelgp]

for sql you can use Count:

select Count(IIF([Appearance]="Excellent",1,Null)) As TotalExcellentAppearance, Count(IIF([Appearance]="Good",1,Null)) As TotalGoodApperance, Count(IIF([Appearance]="Fair And Poor",1,Null)) As TotalFairAndPoorApperance,
Count(IIF([Knowledge]="Excellent",1,Null)) As TotalExcellentKnowledge, Count(IIF([Knowledge]="Good",1,Null)) As TotalGoodKnowledge, Count(IIF([Knowledge]="Fair And Poor",1,Null)) As TotalFairAndPoorKnowledge
From yourTable;

 

[casteverole]

Wow.. thanks for the quick reply.

But how do I use this information? in a query? criteria line?

 

[arnelgp]

create new query.
now on your form, drag a textbox and use =dlookup("TotalExcellentAppearance","qryName") as your recordsource.
if you need to display more textbox just do the same with the rest.

remember to requery these unbound textboxes on the after update event of your combos the get it updated:

private sub comboApperance_afterupdate()
me.textboxTotalExcellentAppenrance.Requery
' other textbox do the same
end sub

 

[casteverole]

Hi Arnelgp,

Many thanks for your time on this , very much appreciated
its a bit more complicated than I thought.

Unfortunately I am a long way off understanding how to implement your instructions :banghead:
However I am learning fast and hopefully will soon be able to

I have saved your information for future use, while I try to understand how access works.

All the best, and thanks again......... Top Man

 

[arnelgp]

this is an example,, maybe you can study this one. its very simple.

 

[casteverole]

Hi Arnelgp,

Brilliant.......This is just what I needed to try and understand whats going on
Thanks very much for your patience and instruction.

You my friend, are a Top Man...

all the best,
Steve

 

[arnelgp]

or simply, without using query in my example, you can just put the recordsource of the textboxes to:

=Count(IIF([Appearance]="Excellent",1,Null))
=Count(IIF([Appearance]="Good",1,Null))
=Count(IIF([Appearance]="Fair And Poor",1,Null))

=Count(IIF([Knowledge]="Excellent",1,Null))
=Count(IIF([Knowledge]="Good",1,Null))
=Count(IIF([Knowledge]="Fair And Poor",1,Null))

 

[casteverole]

Hi Arnelgp,

Top Bod.....