Duplicates In Concatenation

[Guest]

I am trying to print a report with information on alumni. Each page contains
a profile for a former employee. It looks great.

The only problem is that I am having the same profile printed multiple
times. I am using Duane Hookom's concatentation code
(http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Generic
Function To Concatenate Child Records') so that I can include several
1-to-many relations in the printed report. (The is also a many-to-many
relationship, which is included by creating a query and then using that query
to make a one-to-many relationship using the concatenation code).

So each profile looks good, but if there are two phone numbers concatenated
together, I am getting two identical sheets printed for that alumni. any
ideas?

 

[Duane Hookom]

Make the query into a totals/group by query. Either that or base your query
on a table or query that doesn't contain duplicates.

If you can't figure this out, come back with your table and field
information.

 

[Guest]

This is what I have in the report field:
=Concatenate("SELECT TelefonoProf FROM ProfTelefono GROUP BY TelefonoProf
WHERE EmpID =" & [EmpID])

I saw you offer this in another forum:
Select MemberName, Count(*) from MyTableOrQuery Group by MemberName where
Count(*) < 3

But I am having trouble modifying this expression to get it to work...I
would appreciate any help.


"Duane Hookom" escribió:

 

[Duane Hookom]

I assume you are using the Concatenate function as a control source in a
report. If you are seeing too many records in your report, the problem is
the record source of your report, not the function.

If you open the datasheet view of your report's record source, you should
not see multiple telephone numbers for each employee.

--
Duane Hookom
MS Access MVP
--

This is what I have in the report field:
=Concatenate("SELECT TelefonoProf FROM ProfTelefono GROUP BY TelefonoProf
WHERE EmpID =" & [EmpID])

I saw you offer this in another forum:
Select MemberName, Count(*) from MyTableOrQuery Group by MemberName where
Count(*) < 3

But I am having trouble modifying this expression to get it to work...I
would appreciate any help.


"Duane Hookom" escribió:

Make the query into a totals/group by query. Either that or base your
query
on a table or query that doesn't contain duplicates.

If you can't figure this out, come back with your table and field
information.