Report

[Carrie]

Hello
Can anyone help.

I have some data which I want to put into a report. It's best to explain in an example!!! For example 100 people were asked to rate the quality of a meal from 1-5. I want the rating 1,2,3,4 and 5 to appear on my report as labels so that even if as in the case below no one gives a rating of 3 the number three still appears on my report but with a blank value. For example

5 10

4 50

3

2 20

1 20


Is there any coding or anything I can do to do this. I need to do it this way as if I use a query and as in the above example no one gives a rating of three then the number three does not appear in my query and hence not on my report!
I hope this makes sense!
Any help would be greatly appreciated!
Thanks in adance
Carrie

 

[WayneRyan]

Carrie,

A very simple way to do this would be to make a new table with
one field called Rating. Put the numbers 1 - 5 into the new
table giving you five records.

Make a new query, putting the new table on the left and your
table with the ratings on the right.

Join the Entry field (on the left) with your "score" field (on the
right).

Right click and select a type "2" join.

Add the Entry Field to your query.
Add the "score" field to your query.

Select the sigma sign from the menu bar to make this a totals
query.

Choose "group by" for entry.
Choose "sum" for "score" in the totals field.

Done.

hth,
Wayne

 

[Carrie]

Hi thanks for your advice.

I've had a go at doing this but when I apply a filter, it doesn't seem to work! Bit confused!!

Are there anymore suggestions or anything else I can do to sort this problem out?????

Thanks
Carrie

 

[WayneRyan]

Carrie,

Did you get the query to work?

If so, base your report on it.

If not, let's address that.

Filters?

Wayne

 

[Carrie]

Hi Wayne

Just to say I've figured it out in a moment of inspiration.

I've created two queries and it works!

Thanks for your help!
Carrie