C
Chuck
I have a table that contains employees, the department they are in, and
a date that indicates whether or not they have passed an exam. The date
field can also be null. The department heads wanted one form that
contains statistical data... how many employees in each department, and
the stats on how many passed, failed, or not taken (blank) the exam. I
have done this in the form by using the single table as the record
source and creating the form with unbound boxes, but using just a count
or sum of the fields in each box. Works nicely, and it was quick and
easy. I wasn't sure how to do it in a query. Then the dept heads want
a one page report showing the same information. I basically cut/pasted
the unbound fields into the report and presto... I have pages and pages
of the same data printing out. The same number as there are records in
the table. All I want is one page, basically mirroring the single form.
How do I get around the multiple pages? I'm sure there is a query
that can be created instead of unbound boxes in the form/report, but I
could only think of creating several queries which I didn't want to do.
Any ideas? Thanks.
a date that indicates whether or not they have passed an exam. The date
field can also be null. The department heads wanted one form that
contains statistical data... how many employees in each department, and
the stats on how many passed, failed, or not taken (blank) the exam. I
have done this in the form by using the single table as the record
source and creating the form with unbound boxes, but using just a count
or sum of the fields in each box. Works nicely, and it was quick and
easy. I wasn't sure how to do it in a query. Then the dept heads want
a one page report showing the same information. I basically cut/pasted
the unbound fields into the report and presto... I have pages and pages
of the same data printing out. The same number as there are records in
the table. All I want is one page, basically mirroring the single form.
How do I get around the multiple pages? I'm sure there is a query
that can be created instead of unbound boxes in the form/report, but I
could only think of creating several queries which I didn't want to do.
Any ideas? Thanks.