I am a newbie, please help me to do that ...

I have download a databases with synonyms and words with respective ids
from www.rovshan876.narod.ru/Words.rar , I need to obtaing an inform that
list the following

word = synonym1 , synoym2 ...

but only up to 5 synonyms per line

How can I do that. Thanks in advance for your help.

Try this code:

http://www.mvps.org/access/modules/mdl0004.htm
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com


"accessnewbie" u49592@uwe wrote in message news:91a71bcd53e24@uwe...
I have download a databases with synonyms and words with respective ids
from www.rovshan876.narod.ru/Words.rar , I need to obtaing an inform that
list the following

word = synonym1 , synoym2 ...

but only up to 5 synonyms per line

How can I do that. Thanks in advance for your help.

If that doesn't work for you, you might take a look at Daune Hookom's
concatenate function and use it in a query that looks like the following.

SELECT pat_Words.word
, Concatenate("SELECT TOP 5 Synonym FROM pat_Synonyms WHERE Word_id=" &
Word_ID & " ORDER BY Synonym",",") as [Synonyms]
FROM pat_Words

Quoting Duane Hookom

I use a generic Concatenate() function. The code is listed below with
both ADO and DAO. There are comments regarding which lines to comment or
uncomment based on which library you prefer. Access 97 is mostly DAO
while the default for 2000 and newer is ADO.

See:
http://www.rogersaccesslibrary.com/f...sts.asp?TID=16


'================================================= ===
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'================================================= ===


Arvin Meyer [MVP] wrote:
Try this code:

http://www.mvps.org/access/modules/mdl0004.htm