Controls in Reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, I'm afraid I'm quite new to Access, so this might be quite a
rudimentary question.
I have created a report that lists all computer classes that each user is
required to take based on certain scores that are extracted by a query. In
the report I set up six controls, each bound to a separate field in the
query. For example the first control is bound to a column called "Class
one", the second control is bound to "Class two" etc. The problem is that
some users may not be required to take "Class one" and so that field next to
their name in the query is blank. This is fine except that it's leaving an
awful lot of space in the report if say, the user is not reuired to take
classes 1-4, but only 5 and 6. Am I going about this in the wrong way or is
there a way to close up some of the space in the report? Thank you very much.
 
Joanne,
Not sure how you've set this data up. Could you give us an example of
how yoiur report looks, versus how you would like it to look?
Just a few lines of "what I display now", and a few lines of "what I'd
like to see."
And also... some info on your table design and the Classxxx fields.

It may be a case of using a criteria in the Class/s field/s of...
Is Not Null
but, it sounds like if we filter out Null ClassOne's we may lose
legitimate ClassFour's.
 
Here is how the report looks now:

User First Name, User Last Name
Document Formatting


Footnotes



Paragraph Numbering

What I'd like to do is close up the space between the "Document Formatting",
"Footnotes" and "Paragraph Numbering" entries.

The query I use is based on two tables; one is just a list of each user by
first name, last name, index # (primary key). The other table has index #
(foreign key), a field called QNUM (question number on the exam), QSCORE,
Category, Difficulty level etc. So the idea is say if someone scores below a
65 on any question that has a difficulty level of "BEG" then they have to
take a basic formatting class. In the query, I added 6 fields, one for each
possible class that the user would have to take, and then I used and IIF
statement in each field. Here are a few examples

Field Name=Class1 Class1:
IIf([QNUM]=30,IIf([Final]="Incorrect","Footnotes",Null),Null)

Field Name=Class2 Class2: IIf([QNUM]=9 Or [QNUM]=25 Or
[QNUM]=37,IIf([Final]="Incorrect","Print Formatting",Null),Null)

Then on the result set I see something like the following:

LAST NAME|FIRST NAME|Class1|Class2 |Class3|Class4
Doe | Jane | | Print Formatting |
|Document Formatting

So, any of the class fields might be empty. On my report, I added text
boxes bound to Class1, Class2 etc so any user might have up to 5 empty text
boxes on the report.
I hope this clarifies what I've done. Thank you in advance for your help.
 
Back
Top