Concatenate 1 table, 1field "kgrant32" <u47530[ at ]uwe> 11/12/2008 5:25:24 PM 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

Re: Concatenate 1 table, 1field "Damon Heron" <damon_327[ at ]hotmail.com> 11/12/2008 5:36:18 PM 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" <u47530[ at ]uwe> wrote in message news:8d165d9769d79[ at ]uwe... [Quoted Text] > 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 >

Re: Concatenate 1 table, 1field "kgrant32" <u47530[ at ]uwe> 11/12/2008 6:15:08 PM 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; Damon Heron wrote: [Quoted Text] >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