Concatenate 1 table, 1field

[kgrant32]

Hello all, I am new to using modules but that seems to be what I need. I have
a simple task to perform, but just can't figure it out. I have 1 table with 1
field with 11 redords in it that I want to make 1 record. How do I do that?
Thanks

 

[Damon Heron]

Need a little more info, please. Why would you want to make one record out
of 11? do u mean
you want to display all 11 records? If that is the case, use the report
wizard. Otherwise, give us
an example of your table and records.

Damon

 

[kgrant32]

I have a query that is taking fields from a table and making a string. So
basically I have 11 different strings right now. I want to take those 11 and
make them 1 string.

SELECT "Format(Sum(IIf([geocoder]=" & '"' & employee.employee & '"' & ",
[INPUT RECORDS])/DateDiff(" & "'" & "ww" & "'" & "," & employee.[start date]
& "," & employee.[end date] & "))," & '"0"' & ") & " & "" INTO [string]
FROM employee;

Need a little more info, please. Why would you want to make one record out
of 11? do u mean
you want to display all 11 records? If that is the case, use the report
wizard. Otherwise, give us
an example of your table and records.

Damon

Hello all, I am new to using modules but that seems to be what I need. I
have

[quoted text clipped - 3 lines]

that?
Thanks