Helplessly Lost in Concatenate

[shoop]

I have read everything till I'm helplessly lost and know less now then
when I started. I'm afraid someone is going to have to walk me through
the process of setting up and using the Concatenate Funtion. I have
looked again and again at Duane Hookem's example and have yet to get it
to fit/work with my data.Help guy's! Most of us are new to Access and
what we have used with other DB Programs just doesn't work here. I'm
sure I'm not the only one struggling with making this work.

 

[Al Campagna]

What are you trying to concatenate?
Give an example of the items involved.

--
hth
Al Campagna
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."

 

[shoop]

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.