J
james
Hello:
I am working on a report to print on ONE page random selected records from 3
different groups using Access 2000. There are 17 points of concerns and 4
random points of call per group, totaling in 12 random points.
I am not sure what is a more efficient way to achieve this. What I had done
was created 3 similar tables for each group and use select query for the top
4 random numbers.
Drafted report format (manual check off observations are denoted by x, y, z):
From query-1 From query-2 From query-3
Group-A pts of call Group-B pts of call Group-C pts of call
1 2 3 4 1 2 3 4 1 2 3 4
Pt-1 xx x x
Pt-2 x x
Pt-16 yy y
Pt-17 zzz
I managed to put the 17 fields in COLUMNAR format. Printed a report
containing the 4 random points for one group. But I had difficulties in
combining it with the other two groups or queries.
Questions.
1) Is it possible to use sub report to linked the 3 groups? Using the same
label on the far left? And how?
2) How can I pass the 4 records from each query to memory variables? Such
that I can put the variable values across the page. Each query contained 3
fields as Date, Id and Description.
Thank you in advance.
James
I am working on a report to print on ONE page random selected records from 3
different groups using Access 2000. There are 17 points of concerns and 4
random points of call per group, totaling in 12 random points.
I am not sure what is a more efficient way to achieve this. What I had done
was created 3 similar tables for each group and use select query for the top
4 random numbers.
Drafted report format (manual check off observations are denoted by x, y, z):
From query-1 From query-2 From query-3
Group-A pts of call Group-B pts of call Group-C pts of call
1 2 3 4 1 2 3 4 1 2 3 4
Pt-1 xx x x
Pt-2 x x
Pt-16 yy y
Pt-17 zzz
I managed to put the 17 fields in COLUMNAR format. Printed a report
containing the 4 random points for one group. But I had difficulties in
combining it with the other two groups or queries.
Questions.
1) Is it possible to use sub report to linked the 3 groups? Using the same
label on the far left? And how?
2) How can I pass the 4 records from each query to memory variables? Such
that I can put the variable values across the page. Each query contained 3
fields as Date, Id and Description.
Thank you in advance.
James