fields with lookup boxes on my report

[NewCMISGrad]

How can I get results from fields with lookup boxes on my report. I have a table named Questions with fields of questionID(Number) and RoomTemp(text). Room Temp is a lookup box with choices of satisfied, unsatisfied, Don'tKnow. How can I get a count on a report as to how many people answered satisfaction for room temp, Unsatisfied for roomTemp, and a count of Don'tKnows. I am really new to Access. I have written the report, tables, queries many ways and can't seem to get it right.

Thank You so Much,
NewCMISGRad

 

[dhookom]

Do you want detail and summary information?
Do you have a few records and desired output?
Are your choices coming from a table?
Did you use the dreaded anti-feature of Lookup Fields in tables?

http://www.mvps.org/access/lookupfields.htm

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[NewCMISGrad]

Right now all that my boss wants is summary information. I will input approx 50 records a week into the table. No my lookup field is not coming from a table, although I have a table with the answers. I will read the evils of lookup boxes as you suggest and re-think my tables. Thanks.

Thank You so Much,
NewCMISGRad

 

[dhookom]

If you would provide some sample records and desired output, I'm sure that someone would give you some direction.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.