If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Duplicates In Concatenation
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? |
#2
|
|||
|
|||
Duplicates In Concatenation
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. -- Duane Hookom MS Access MVP -- "Wynn" wrote in message ... 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? |
#3
|
|||
|
|||
Duplicates In Concatenation
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. -- Duane Hookom MS Access MVP -- "Wynn" wrote in message ... 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? |
#4
|
|||
|
|||
Duplicates In Concatenation
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 -- "Wynn" wrote in message ... 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. -- Duane Hookom MS Access MVP -- "Wynn" wrote in message ... 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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Avoiding or removing duplicates in a public folder | Craig | General Discussion | 3 | August 31st, 2005 01:19 AM |
Delete Duplicates | box2003 | Running & Setting Up Queries | 0 | May 16th, 2005 01:42 PM |
Hide duplicates off = OK; hide duplicates on = #name? | C. Lombardo via AccessMonster.com | Setting Up & Running Reports | 0 | April 28th, 2005 02:14 PM |
I am receiving multiple duplicates of the same email | Berni | General Discussion | 5 | March 9th, 2005 10:35 PM |
How are duplicates suppressed? | Sam Hobbs | Setting Up & Running Reports | 3 | September 3rd, 2004 03:12 AM |