Jim,
You can use the generic Concatenate() function at http://www.tek-tips.com/faqs.cfm?fid=4233. This one function can be used for concatenating as well as domain aggregate functions like DMax(), DSum(), DLookup(), etc.
You can supply any delimiter you desire. The comma is the default.
Duane Hookom, MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Sat, 31 Jan 2015 22:18:30 +0000
Subject: Re: [MS_AccessPros] Consolidated multiple records into 1 field
You can use the generic Concatenate() function at http://www.tek-tips.com/faqs.cfm?fid=4233. This one function can be used for concatenating as well as domain aggregate functions like DMax(), DSum(), DLookup(), etc.
You can supply any delimiter you desire. The comma is the default.
Duane Hookom, MVP
MS Access
To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Sat, 31 Jan 2015 22:18:30 +0000
Subject: Re: [MS_AccessPros] Consolidated multiple records into 1 field
sean48,
I put the email addresses in a table with the Department as part of the record such as
Then have the email part of the code do a dlookup based on the department.
Jim Wagner
On Saturday, January 31, 2015 8:51 AM, "sean48_48@yahoo.com [MS_Access_Professionals]" <MS_Access_Professionals@yahoogroups.com> wrote:
I am writing the e-mail in outlook and then want to copy in the e-mail addresses that are stored in access based on those that meet a certain criteria. I have 400 records in Access and might need 300 e-mail addresses and am looking for a easy way to consolidate them systemically.
__._,_.___
Posted by: Duane Hookom <duanehookom@hotmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (5) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar