Data formats (1 Viewer)

[Agent Smith]

OK; hello access wizards

this is the problem i have, one in a million others;

i have this table is suposed to be an inquirie to an hotel costumers.
So when awnsering the questions, the data are text fields whith pre formated data like " Very good" "Good" "sufficient" "Bad".

If i wanted to make a query by costumer and then from it produce a data grafic, what am i suposed to do, for the text data can not be averaged or summed or divided.

Can anyone help whith this elefant problem (to me; i know nothing about programing etç.

thanks in advance

 

[WayneRyan]

AgentSmith,

You can put together a query:

Select SomeField, Count(*) As HowMany
From   YourTable
Group By SomeField;

That will give you the counts for
each response.

Wayne

 

[Pat Hartman]

Rather than storing text values, store numeric values. You can still show the text values on forms and reports but numeric values can be used for calculations.

Make a table with two columns:
RatingID, RatingName
1, Bad
2, Sufficient
3, Good
4, Very Good

Make the key RatingID and also create a unique index for RatingName to prevent duplicates.

Use this table as the rowsource for a combo on your data entry form. The wizard will build it for you. It will let you choose from the text values but store the numeric value.