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
|
|||
|
|||
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. |
#2
|
|||
|
|||
I am a newbie, please help me to do that ...
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. |
#3
|
|||
|
|||
I am a newbie, please help me to do that ...
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 |
Thread Tools | |
Display Modes | |
|
|