Reports - Sorting and Grouping Header misalignment

  • Thread starter Thread starter JustinP
  • Start date Start date
J

JustinP

I have a report with a group header, X, and then some other fields in
the detail section, Y and Z. Is there anyway to make X appear to be on
the same line as Y and Z?

I have more than Y/Z for one X in some instances. For example, the data
in the report may look like this:

-----------------------------------------
X
Y Z
-----------------------------------------
X
Y Z
Y Z
Y Z
 
hi all
i have question about VB programming in access
i have created school system so that i was using average grade to determine
if student take A, B+,...etc
but when it run it don't execuetd well, it only run two last statement of if
statement!!??

my code was:
Private Sub evaluation_Enter()
If average >= 3.24 Then
evaluation = "A"
End If

If average > 2.49 Then
evaluation = "B"
End If

If average > 1.73 Then
evaluation = "C"
End If

If average > 0.9 Then
evaluation = "D"
End If

If average < 0.9 Then
evaluation = "F"
End If

so plz can any one tell me what up with me???
 
Just move the textbox for "X" to the detail section, leaving the group header
empty. Drag the bottom line of the group header section up to reduce the size
to zero.
 
How have you declared average? You're not passing it to the routine, so
unless it's been defined as a global variable, it's going to have a value of
0 inside the routine (assuming you haven't turned Option Explicit on as you
should)

By the way, you need to use ElseIf, or a SELECT CASE statements:

If average >= 3.24 Then
evaluation = "A"
ElseIf average > 2.49 Then
evaluation = "B"
ElseIf average > 1.73 Then
evaluation = "C"
ElseIf average > 0.9 Then
evaluation = "D"
Else
evaluation = "F"
End If

With your code, a value of 4 would result in D, because the statement If
average > 0.9 Then will be true.
 
Back
Top