I have two final problems in creating my report.......

[NeilBelgium]

I have two final problems in creating my report.......

I want my report to be based on two queries.
The first is simple, and is completed, and look something like this:

QuestionNumber Boss Peer Self Average
1 5 4 4 4.3
2 4 4 4 4
3 3 3 3 3
4 "" "" "" ""
5 "" "" "" ""
6 "" "" "" ""

this goes on for 24 questions, i'm sure you get the idea.
HOWEVER, I also need to build a query that will give totals for the columns
for six questions at a time. all 24 is easy, but how split into sixes, and
produce a query that looks like this:

QuestionGroup Boss Peer Self Average
1 -6 5 4 4 4.3
7-12 4 4 4 4
13-18 3 3 3 3
19-24 4 4 5 3.7
(i know-the numbers don't add up but it's not important!!)

that's major (to me) problem one.

Problem two is that the report,a s well as displaying the results from this
second query , I'm going to add some written reports.

Let's take the first group of questions. If the overall average is between
1-3, I want one written report to appear. If the average is 4-5, another
written report is produced.
Now, I have all these written reports, but in what format do I store them,
and how on earth do I call upon them in the access report?

muchos thankyous to anyone that can assist!!

yours, neil

 

[howardjones]

Neil why not try making the report visible in the detail
for example try
if blah = 1-3 then
report1.visible = true
elseif
blah = 4-5 then
report2.visible = true
and so on
hope it helps

 

[NeilBelgium]

dear howard,

not sure I understand! you are unfortunately dealing with a complete amatuer here - could you please explain in really simple terms what I need to do?
much appreciated, neil

 

[JaneC]

Neil,

You could have another table constructed as follows :

QNum QGrp
1 1 - 6
2 1 - 6
3 1 - 6
..
7 7 - 12
8 7 - 12
..
etc

Then link this into the query so you you can use QGrp as the Row for the crosstab

HTH

Jane

 

[NeilBelgium]

ok, there still appears to be one small issue: (surprise, surprise!!)

I have created a table with the textreports:

QuestionGroup
low
medium
high

which houses the twelve options.

How on earth do I synchronize this with the query I have which produces the report, which is, after all, based on grouping and numerical averages.
The report won't accept both table and query to produce the report, so somehow I've gotta get these memo fields into a query from which I can use it.
does this make sense?????
neil