Re: Helplessly Lost in Concatenate
- From: shoop@xxxxxxxxx
- Date: 22 Dec 2006 06:14:59 -0800
I can't figure out how to make this work.
For each Form the Inspector uses, they will put up to 5 audits for each
Form.
This means that I will have 5 separate Audits for each Record in my
Table
(Flag Audits). I also then have 5 Audits per record in my Query. My
Query
(Flag Audits Query) shows Columns Repair/Reject Comments 1 thru
Repair/Reject Comments 5. In addition I have 5 additional Columns where
for
the Field I have Repair1: IIf([Pass/Repair/Reject
1]="Repair",[Repair/Reject
Comments 1],"") thru Repair5: IIf([Pass/Repair/Reject
5]="Repair",[Repair/Reject Comments 5],"").
I have the same for Reject except
the Field Names are Reject1: IIf([Pass/Repair/Reject
1]="Reject",[Repair/Reject Comments 1],"") thru Reject5:
IIf([Pass/Repair/Reject 5]="Reject",[Repair/Reject Comments 5],"").
On my Report I have 5 Controls named Repair1 thru Repair5 and 5
Controls Reject1
through Reject5. These are not Visable on the displayed Report just in
the
Design View. I do display on my Report a Control Repair and another
Control
Reject which are visable on the Report. In my Code I have varRepair =
(Me.Repair1 + Me.Repair2 + Me.Repair3 + Me.Repair4 + Me.Repair5) and
If IsNull(varRepair) Then
Me.[Repair] = 0
Else
Me.[Repair] = varRepair
End If"
and varReject = (Me.Reject1 + Me.Reject2 + Me.Reject3 + Me.Reject4 +
Me.Reject5) and
If IsNull(varReject) Then
Me.[Reject] = 0
Else
Me.[Reject] = varReject
End If
I thought this would work but it doesn't.
.
- References:
- Helplessly Lost in Concatenate
- From: shoop
- Helplessly Lost in Concatenate
- Prev by Date: RE: Report Problems
- Next by Date: Eliminating unnecessary data in a report
- Previous by thread: Re: Helplessly Lost in Concatenate
- Next by thread: Help with multi-table report
- Index(es):
Relevant Pages
|
