Why are you storing all of these values in a single field. Wouldn't it be
easier to use separate fields for each element, then your searching would be
a lot simpler to do
Macromedia Certified Professional for Dreamweaver MX2004
Valleybiz Internet Design
Team Macromedia Volunteer for Ultradev/Dreamweaver MX
"tim-p" <webforumsusermacromedia.com> wrote in message
news:d30p88$308$1forums.macromedia.com...small> Hi I have an Access db which stores, amongst other things, details ofis> mailing lists, people who have received a particular mailing. Because itidentities of> Access, and therefore no stored procedures to do the insert, the1> the people who have received a mailing are held in a memo field as a comma
> delimeted string. e.g. ListID Date MailingList15,> 01/04/2005 3, 7, 99, 107 2 13/04/2005 2,variable:> 27, 136 etc. It is easy enough to extract the recipients from one
> particular list: select one listID, set the field Mailing list as aselect> varMailingList2 = (rsDraftList.Fields.Item('MailingList').Value) thenSELECT *> from the people table all those peopleIDs who are in varMailingList2:')> FROM qryCampaigns_maillist WHERE RoleID IN (' & varMailingList2 &more> However, I now need to find all people contacted from any list between two
> dates. Therefore my method above falls over because there could be one orthoughts on> records in recordset rsDraftList (or indeed none). Anyone have any> the easiest way to do this? Can you concatenate instances in a recordset?
> Thanks in advance for any suggestions.